[40] in SAPr3-news
Re: Access DB2 from R/3
daemon@ATHENA.MIT.EDU (Michael Nelson)
Mon Apr 17 15:49:58 1995
To: sapr3-news@MIT.EDU
Date: 6 Apr 1995 14:48:15 GMT
From: menelson@ix.netcom.com (Michael Nelson)
In <upfaendl.1.0008A8CC@dial.eunet.ch> upfaendl@dial.eunet.ch writes:
>
>Hello everybody
>
>We are currently using the SAP Gateway to access R/2 from R/3 (or R/3
form
>R/2). Now we need to access DB2 data (on MVS) from R/3. Does anybody
have
>experience in this field?
>
>Any help would be appreciated,
>
> Urs
Pfaendler
>
Assuming that Oracle is the D/B, here's a possible solution:
Install a run-time Oracle instance on MVS, along with a product from
Oracle called SQL*CONNECT. This product allows you to define your
external (DB2) data structures as Oracle tables. Now define your DB2
tables as R/3 tables using the database maintenance utilities. After
activation, use a combination of Oracle synonyms and database links to
provide access to the DB2 structures from ABAP.
I have NOT done this using MVS; however, I used this technique to access
RMS data on a VAX running VMS5.2 from R/3 on Oracle on HP-UX.
Mike Nelson
menelson@ix.netcom.com