Xref: alice comp.databases.oracle.server:74961 Path: alice!news-feed.fnsi.net!enews.sgi.com!paloalto-snf1.gtei.net!news.gtei.net!inet16.us.oracle.com!not-for-mail From: "Yass Khogaly" Newsgroups: comp.databases.oracle.server Subject: Re: Loading EBCDIC binary file into a UNIX environment Date: Sat, 20 Nov 1999 11:59:10 -0800 Organization: Oracle Corporation. Redwood Shores, CA Lines: 35 Message-ID: <816qug$e6p$1@inet16.us.oracle.com> References: <3836EC25.4ECB9995@sympatico.ca> X-Trace: inet16.us.oracle.com 943124240 14553 144.25.235.115 (20 Nov 1999 18:57:20 GMT) X-Complaints-To: usenet@inet16.us.oracle.com NNTP-Posting-Date: 20 Nov 1999 18:57:20 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 > 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 wrote in message news:3836EC25.4ECB9995@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. >