RE: Access Oracle from RPG

[Marcel Sjardin <m.sjardin@xxxxxxxxx>]

You can also try this:
Take a Windows PC
Install the Oracle ODBC driver
Install the Client Access ODBC driver
Use MS Access to copy the file

It's not very fast, but it takes care of the conversions.

At 16-10-2002 15:15 -0400, you wrote:
> 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