Re: Load EBCDIC datafile via SQL*Loader

From: <tony.rodgers_at_cox.com>
Date: Mon, 25 Jan 1999 19:32:38 GMT
Message-ID: <78igsm$3h2$1@nnrp1.dejanews.com>

In article <36aa733a.7314577_at_news.netfront.net>, josamng_at_netfront.net (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 ?
>

You should be especially careful if you are moving fields from an EBCDIC system to an ASCII system when some of the fields are either binary or packed- decimal. These fields will end up being scrambled during the transition to your ASCII system. If you must transfer these fields in their original format, there are some products on the market like Syncsort's Fileport which will automatically unscramble the binary and packed-decimal fields after they have been transfered.

Tony Rodgers

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Jan 25 1999 - 13:32:38 CST