Re: SQL*Loader question
Date: 2 Dec 1994 15:26:31 GMT
Message-ID: <Rob_Smith-021294153254_at_nnsgm22.lon40.nt.com>
In article <1994Nov29.181635.13598_at_rs6000.cmp.ilstu.edu>, smblair_at_rs6000.cmp.ilstu.edu (Steve Blair) wrote:
> I am trying to load a file that was created from a VSAM file on the
> mainframe. We have to download or ftp in binary mode because there
> are binary and packed decimal numbers. Now we can't get the character
> data to load correctly - it is garbage. Can SQL*Loader convert from
> EBCDIC to ASCII? Any help would be very much appreciated. BTW the numeric
> data converted fine.
> --
> Steve Blair Information Systems
> Illinois State University internet: smblair_at_ilstu.edu
> Campus Box 3470 voice: 309/438-2071
> Normal, IL 61790-3470 fax: 309/438-3027
You don't say what platform you are running on, but if it is unix the 'dd' command provides a quick and easy EBCDIC to ascii conversion. Received on Fri Dec 02 1994 - 16:26:31 CET