Re: SQL*Loader and EBCDIC data.

Satish Reddy (reddys_at_netcom.com) wrote: [...]
>I have tried "load data characterset WE8EBCDIC500" in control file.
>I do not get any errors but the log file contains " total logical
>records read: 0".

As the message suggests, the problem lies with the input file processing. My guess is that the UNIX i/o routines are expecting each record to be terminated by a newline character (an ASCII newline no less, since 'characterset' applies only to data fields being loaded).

I don't have the doc handy to look at but I think you need to investigate what Oracle on Sun permits for the "OS-dependent file processing specifications string" in the INFILE clause. What you need to specify depends on the exact layout of your EBCDIC input file.

Once you get the input working properly the load should go ok. I just tried a simple 'characterset WE8EBCDIC500' test case and it works fine in 7.0.16.

/b