Hi Friends,
Today i just got the below errors in one of my jobs(Fixed-width sequential file).
column unexpectedly ended by EOR
All i need to do is just need to reject that particular row and create the bad records and process the remaining correct records.
Please let me know how to capture the ended by EOR records.
Thanks,
Satheesh
column unexpectedly ended by EOR
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 182
- Joined: Thu Jun 16, 2005 2:05 am
What I suggest you do is read the data as variable width string of say 30000 and then for each line test its length in a transformer
If the row is too short , reject it and then with the correctly formatted lines process those in another transformer
If the row is too short , reject it and then with the correctly formatted lines process those in another transformer
Colin Larcombe
-------------------
Certified IBM Infosphere Datastage Developer
-------------------
Certified IBM Infosphere Datastage Developer