Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Load EBCDIC datafile to Oracle table by SQL*Loader.
Hi. dd won't convert packed decimal fields properly. Better is to bring the
file over as binary. Use dd to unblock the records at record length. Then
have SQL*Loader import the file using the 'charcterset <original charset>'
clause. For packed decimal fields, I believe, the data type is decimal.
Loader will convert the binary ebcdic characters into the characterset of
your database, and handle packeds properly.
If you need more info contact me directly. HTH,
Yosi Greenfield
ygreenfield@^netscape.net (remove the ^)
Larry Reid wrote:
> Check out the Unix command dd(1). It has some capability for converting
> EBCDIC to ASCII and vice versa. Be aware, however, that there isn't one
> EBCDIC coding scheme. I don't remember the details of the differences
> between different EBCDIC encodings. You may want to investigate this
> before converting all your data.
>
> In article <36aa7333.7308191_at_news.netfront.net>, josamng_at_netfront.net
> (Explorer) wrote:
>
> >How can I load a datafile with data in EBCDIC format into an Oracle
> >database table in UNIX platform (e.g. AIX) by SQL*Loader ?
> >
> >Any sample setup and/or control file example are welcome.
>
> --
> Larry Reid lcreid@^web.net (remove the ^)
Received on Wed Jan 27 1999 - 22:43:58 CST