Re: SQL*LOADER and EBCDIC

From: Mike Rushton <mike_at_mrush.demon.co.uk>
Date: 1996/12/10
Message-ID: <32ac6a2f.912908_at_news.demon.co.uk>#1/1

Steve McAllister <smm_at_interramp.com> wrote:

>I have a few large (250MB+) IBM DB2 EBCDIC files that I currently use
>DataJunction to convert to a SQL*LOADER .DAT file for loading into a
>Oracle 7.3 DB on a SUN UNIX box. The problem is that each file takes
>about 6-7 hours to convert and I need some speed ups. I have read the
>Oracle Server Utilities manual from end to end and cannot see any
>obvious way to import an EBCDIC file. If am missing something please
>point me in the right direction.

Steve,
If my memory is right, SQL*Loader does not support EBCDIC files, however, if you are using Unix you can use the 'dd' command to convert them to ASCII and then use SQL*Loader

Mike Rushton
mike_at_mrush.demon.co.uk Received on Tue Dec 10 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Ron Strouss: "Re: Setting SQL*Plus Prompt"
Previous message: AWILSON: "Re: Selecting columnnames from other table"
In reply to: Steve McAllister: "SQL*LOADER and EBCDIC"
Next in thread: Ron Strouss: "Re: Setting SQL*Plus Prompt"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message