Loading variable length EBCDIC SQL Loader

[cdutta]

I 've been trying to load an EBCDIC file that has variable length rows. The first row seems to load fine but the rest of the rows are all messed up.
There are no delimiters for the rows and I do not know how to
get this thing loaded ... the FIX 682 option in the example below is wrong ... but it still loads the first row...
This is a sample of the control file...

LOAD DATA
characterset WE8EBCDIC500
infile 'COD0278.text' "FIX 682"
badfile 'COD0278BD.txt'
INSERT
into table RISK.TBLCOLLECTION_BASE_STAGE
WHEN CMW_RECORD_TYPE = X'F1'
trailing nullcols
(CMW1 POSITION (1 : 1) CHAR,
CMW2 POSITION (2 : 2) Graphic,
CMW3 POSITION (3 : 3) CHAR,
CMW4 POSITION (4 : 4) CHAR)

Did anyone have done this before? Please help.
Thanks,
CD

[aghosh]

Hi,
What I feel is that, if you have a variable length datafile it has to be delimited....otherwise it has to mess up.

See what ever position you r specifying for the fields that is not correct for all the rows in case of a variable length datafile.

Try to get the file delimited or pad fields with blanks to make it fixed length.

Thanks

Amit