Re: Mainframe data

DO NOT ftp in text form, use binary. Transfering usin text will convert accents, packed decimal field to junk or sometime remove the bytes completly. Transfer in binary mode and convert on Unix. SQL*Loader can read EBCDIC data, packed decimal fields and do the convertion properly (except with a knowned problem with the "|").

Regards,

Marc Mazerolle

Fred wrote:

> Unfortunately I don't have any of the tools mentioned here and it is not
> feasible to get any of the tools. Currentely, I am unloading the data in
> the table to a flat file with mainframe tool than ftp (text file, not
> binary) to Unix. The Oracle people, however, complained that the format is
> inconsistent, the space between each column is inconsistent. Some
> characters cannot be read. (I believe that is because unreadable charactor
> is some of the data). In mainframe side, the data is consistent.
>
> Fred
> Fred <yiu.shih.lee_at_cdsi.com> wrote in message
> news:7ede9g$h0o$1_at_clarknet.clark.net...
> >Can you load mainframe DB2 data into Oracle? If yes, what is the best way
> >to approach it? My understanding is that DB2 doesn't convert it into
> >Oracle, the Oracle side has to do the convertion? Am I right?
> >
> >Thanks in advance.
> >
> >Fred
> >
> >
Received on Thu Apr 08 1999 - 08:48:16 CDT