Re: loading EBCDIC with sqlload

From: Jim Finch <jbfinch_at_akron.infi.net>
Date: 1997/02/20
Message-ID: <330CE581.40F3@akron.infi.net>#1/1

Jim Finch wrote:

> I am also having problems with a WHEN clause. I am comparing columns 4:8
> with 'BATCH' and never get it to equal eventhough I know there are
> records that match. Do I have to convert 'BATCH' to EBCDIC?
>

> > OPTIONS (direct=true)
> > UNRECOVERABLE
> > LOAD DATA CHARACTERSET WE8EBCDIC500
> > INFILE '/home/ee18/data/buck.ebcdic' "FIX 64"
> > BADFILE '/home/ee18/data/buck.bad'
> > DISCARDFILE '/home/ee18/data/buck.dis'
> > INSERT
> >
> > INTO TABLE BUCK001
> > WHEN (4:8) = 'BATCH'
I have the packed data converting. I am still having problems with thisk WHEN clause. I know that the data comming in does match this comparison. Does anywone have any pointers for me.

Jim Finch
jbfinch_at_calibersys.com Received on Thu Feb 20 1997 - 00:00:00 CST