RE: Access Oracle from RPG

I had dealings with a large retailer recently who uses an Iseries and also some 
app that uses an Oracle database.  In order to
exchange files Iseries to Iseries, we had to hardcode a comma between each 
field.  When I asked them why, she said that was because
the Oracle guys read her database and they can only do it if the commas were in 
there.

I couldn't send a true CSV, with a simple zero representing 0 qty, like 0, I 
had to send 00000, and if an alpha field was defined as
20, and I only had 10 characters, I had to pad with blanks.

_________________
Art Tostaine, Jr.
CCA, Inc.
Jackson, NJ 08527

> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of Marcel Sjardin
> Sent: Wednesday, October 16, 2002 3:52 PM
> To: rpg400-l@midrange.com
> Subject: Re: Access Oracle from RPG
>
>
> We've tried the Oracle bridge product, but:
> 1) it's not very stable,
> 2) you need SQL or SQLRPG (or something like that) to access the Oracle DB.
>
> We are now using DataMirror to replicate the Oracle and DB/2 database (both
> ways) on a realtime basis.
>
> Regards,
> Marcel Sjardin
>
> At 16-10-2002 12:01 -0400, you wrote:
> >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.
>