Re: Access Oracle from RPG

["Dare" <oludare@xxxxxxxxxxxxx>]

It was a BPCS environment and a real-time access was needed to and from
ORACLE db.  We used a MIDDLEWARE written in C that reside on the AS/400 as a
DAEMON.  Triggers were define for the MIDDLEWARE that checks for event in
ORACLE db (in a manufacturing environment) and other events were driven on a
real time basis.  The middleware is call SMGs (Semantic Message Gateways).
Check out the bpcs-l@midrange.com list for more info.  Need more info??????


----- Original Message -----
From: "Guliani, Vineet (IndSys, MFG Non GE)" <Vineet.Guliani@indsys.ge.com>
To: <rpg400-l@midrange.com>
Sent: Wednesday, October 16, 2002 1:44 PM
Subject: RE: Access Oracle from RPG


> thanks Dare,
>
> it would be gr8 if you could plz. elaborate on this.
> if not the exact details then just the outlines.
>
> Vineet Guliani
>
> -----Original Message-----
> From: Dare [mailto:oludare@ix.netcom.com]
> Sent: Wednesday, October 16, 2002 1:40 PM
> To: rpg400-l@midrange.com
> Subject: Re: Access Oracle from RPG
>
>
> Don't quote me on this but I did work in a shop where it was possible.
You
> can use a DAEMON adapter for ORACLE using TCP/IP.
>
> ----- Original Message -----
> From: "Booth Martin" <Booth@MartinVT.com>
> To: <rpg400-l@midrange.com>
> Sent: Wednesday, October 16, 2002 1:36 PM
> Subject: Re: Access Oracle from RPG
>
>
> >
> > Would you receive a better answer if you were to ask the person that
sold
> > you on the Oracle database?  They are the ones that make the promises.
> Let
> > them keep their promises.
> >
> >  (The roadway of transition to Oracle's database seems littered with
> > failures, the most recent being the LexMark disaster.  What was that?  A
> $15
> > million+ software writeoff?)
> >
> > ---------------------------------------------------------
> > Booth Martin   http://www.MartinVT.com
> > Booth@MartinVT.com
> > ---------------------------------------------------------
> >
> > -------Original Message-------
> >
> > From: rpg400-l@midrange.com
> > Date: Wednesday, October 16, 2002 12:05:56 PM
> > To: 'rpg400-l@midrange.com'
> > Subject: Access Oracle from RPG
> >
> > Hi,
> >
> > Is it possible to access Oracle database through RPG on AS400.
> > Just like the way we access DB2 on the AS400.
> >
> > This is for the case when I want to move my database to Oracle but
> > would
> > like my RPG programs to run the same way on AS400 as they run now.
> >
> > Regards,
> > Vineet Guliani
> > _______________________________________________
> > This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing
list
> > To post a message email: RPG400-L@midrange.com
> > To subscribe, unsubscribe, or change list options,
> > visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> > or email: RPG400-L-request@midrange.com
> > Before posting, please take a moment to review the archives
> > at http://archive.midrange.com/rpg400-l.
> >
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>