Re: Can SQL Loader handle Packed Decimals in a Binary File?

Thushy2311_at_hotmail.com (Thushy T) wrote in message news:<d94d093b.0304110700.5e106096_at_posting.google.com>...
> When an EBCDIC Variable length record file with packed decimals and
> printable characters get transferred to UNIX. How it can be loaded to
> an Oracle database using SQL Loader.
>
> Any feed back will be appreciated.
>
> Thanks
> Thushy T

Hi there,

I too use SQL loader to load files into Oracle (unix box) coming from a Siemens BS2000 mainframe.

During simple file transfer conversion from ebcdic to ascii takes place. The file tranfer uses a code table to achieve this. Transferring packed decimal will result in a mess on the unix machine. Before using SQL loader you would have to run a custom program on it to decode the file (tricky).
However it should be quite easy to create an intermediate file on your ebcdic machine without fields having usage packed decimal, usage binary, ... using some utility. I strongly recommend you to take a good look at the char-sets used on your EBCDIC machine, the transfer code table, ASCII and EBCDIC tables.

regards,
Stef Received on Sat Apr 12 2003 - 11:05:07 CEST