Re: Load EBCDIC datafile via SQL*Loader

From: Christopher M. Day <christopher.day_at_rdbms.freeserve.co.uk>
Date: Sun, 24 Jan 1999 23:28:17 +0000
Message-ID: <36ABAC91.12642D1@rdbms.freeserve.co.uk>

Hi,

Depends if you have verablock information or other none printable characters in the ebcdic file, if you don't use the unix 'dd' command and the conversion options e.g.

dd if=in of=out conv=ascii cbs=80 ibs=6400 obs=512

Converts 80-byte fixed length EBCDIC card images in 6400 byte input blocks to variable length ASCII lines, 512 bytes to the output block.

Hope this helps.

Chris.

Explorer wrote:
>
> Hi, anybody out there having the experience of loading a EBCDIC
> datafile to an Oracle database table on Unix ASCII platform ?
>
> Any special setup hints and sample script are welcome ?
Received on Sun Jan 24 1999 - 17:28:17 CST