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
Trying to read fixed length flat file from IBM on Linux box
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 19
- Joined: Fri Aug 03, 2012 11:06 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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?
Also, the warning is "command not found". What command are you trying to execute? Is your PATH inclusive of this command's parent directory?
Last edited by ray.wurlod on Thu Mar 21, 2013 3:18 pm, edited 1 time in total.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 19
- Joined: Fri Aug 03, 2012 11:06 am
Figured it out !!!
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 !!
Thanks guys !!