DSXchange

Posted: **Thu Mar 21, 2013 11:41 am**

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

Posted: **Thu Mar 21, 2013 12:23 pm**

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

Posted: **Thu Mar 21, 2013 3:02 pm**

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?

Posted: **Thu Mar 21, 2013 3:05 pm**

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.

Posted: **Thu Mar 21, 2013 3:19 pm**

One must assume that EBCIDC is a typo for EBCDIC.

Posted: **Fri Mar 22, 2013 12:52 pm**

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 !!

DSXchange

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

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

Figured it out !!!