Trying to read fixed length flat file from IBM on Linux box

[william.eller@ed.gov]

When I use a Sequential File Stage - generates errors and warnsing that seem to be based on no \r\n at end of each record

When I use a CFF fixed\EBCIDC generated error on 1st record :

##W IIS-DSEE-TOIX-00175 13:17:58(000) <stagename> Source subproc: /opt/ibm/iis/Server/Projects/D2I/SrcFiles/NSLDSP_LNDEFRT_tst.dat_BKUP: line 1: <input record> : command not found

Please help me

[suja.somu]

Could you post the structure of the fixed width flat file along with sample data ?

[ray.wurlod]

You're on UNIX - why are you expecting Windows line terminators?

Also, the warning is "command not found". What command are you trying to execute? Is your PATH inclusive of this command's parent directory?

[PaulVL]

Are you sure the data is EBCIDC?

You can try a "dos2unix yourfilehere.txt" on it to fix it up.

I would not recommend a dos2unix to be done on an EBCIDC file.

[ray.wurlod]

One must assume that EBCIDC is a typo for EBCDIC.

[william.eller@ed.gov]

Thanks for the quick responses (and yes typo on EBCDIC). I was using wrong options (Format Tab > Record Delim String was "DOS") and Column SQLTYPE changed to mix of Char and VarChar

Thanks guys !!