Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: SQL Loader with EBCDIC File

Re: SQL Loader with EBCDIC File

From: <tedchyn_at_yahoo.com>
Date: Sat, 12 Jun 1999 16:48:44 GMT
Message-ID: <7ju31a$d65$1@nnrp1.deja.com>


In article <7jth9u$pjl$1_at_bgtnsc03.worldnet.att.net>,   "Juan Carlos" <jc_va_at_hotmail.com> wrote:
> Thanks for the responses to my personal e-mail. The EBCDIC file I am
> dealing with is extremely large. What I want to do read it and
convert it
> with SQL Loader. Is there any way to do that?
>
>

Juan,
You can incoported decode,translate and other oracle function in control file to load your ebdic file. I had to do that to convert pack field to number in oracle.

Ted

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Jun 12 1999 - 11:48:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US