Hi,
I'm new to DS and have a problem.
I created a delimited file using DS Mainframe, then sent it to my C drive and tried to read in a DS Server Sequential Stage. The Job processed all records except the last one and abended with msg
***
test_famrtb..Read_famrtb.DSLink3: read_delimited() - row 86062, column TIM_STP, required column missing
***
when I checked my input file, found that the las record has character ''
***
2005-11-14,2005-11-15-05.12.51.709985,T0A,2006-06-07,.00
2005-09-28,2005-09-29-05.12.08.580573,T1W,2006-06-07,.00
2005-10-26,2005-10-27-05.11.56.618863,T1X,2006-06-07,.00
***
deleted the last record, rerun my Job successfully.
In our project we are supposed to process files received from Mainframe. It is impossible to edit every file manually. Did anybody have this problem? Any suggestions?
Please help!!!
DS Server abends reading file received from Host
Moderators: chulett, rschirm, roy
Welcome Aboard 
You have an extra line at the end. This happened to me too once, when I NDM'd the file from the mainframe over to the file server on windows. The best way to handle it , is to go to the column tab in the sequential file stage, and set the 'Contains Terminators' of the last row to Yes.
You have an extra line at the end. This happened to me too once, when I NDM'd the file from the mainframe over to the file server on windows. The best way to handle it , is to go to the column tab in the sequential file stage, and set the 'Contains Terminators' of the last row to Yes.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Thanks a lot!
You helped me to find my own solution. Changing Contains Terminator flag to Yes didn't work because it specifies how EndOfRecord is treated. I have a problem with EndOfFile.I changed Incomplete Column action from Error to Discard+Warn for all columns and the last record now is ignored. It works fine for me since I created the file on Mainframe and don't have to check if columns are populated. :D
You helped me to find my own solution. Changing Contains Terminator flag to Yes didn't work because it specifies how EndOfRecord is treated. I have a problem with EndOfFile.I changed Incomplete Column action from Error to Discard+Warn for all columns and the last record now is ignored. It works fine for me since I created the file on Mainframe and don't have to check if columns are populated. :D