Re: Loading EBCDIC binary file into a UNIX environment

> Does anyone has done a load from a MainFrame binary file (EBCDIC char
> set) into Oracle 8 for UNIX (AIX)?

CONVERTING BETWEEN ASCII AND EBCDIC

  The "dd" Unix command can be used to convert EBCDIC data files to ASCII and vice-versa. For example:

          % dd if=example1.ebc conv=ascii > example1.asc

  takes example1.ebc as EBCDIC input file, converts it into ASCII, and writes the converted output to file example1.asc.

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

Pierre Carrier <pierre.carrier_at_sympatico.ca> wrote in message news:3836EC25.4ECB9995_at_sympatico.ca...

> Does anyone has done a load from a MainFrame binary file (EBCDIC char
> set) into Oracle 8 for UNIX (AIX)?
>
> Since we have large file to transfer and load, we are looking to do
> the FTP transfer in a binary mode instead of ASCII mode to reduce the
> time to transfer the data across the network. But to acheive that we
> would require Oracle to be able to read and load that binary file coming
> from the MainFrame. Going through the documentation of Oracle I didn't
> find anything on this. So if anyone knows how and would be willing to
> share this information, it would be very helpfull.
>
> Thanks in advance.
>
Received on Sat Nov 20 1999 - 13:59:10 CST