column unexpectedly ended by EOR

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
satheesh_color
Participant
Posts: 182
Joined: Thu Jun 16, 2005 2:05 am

column unexpectedly ended by EOR

Post by satheesh_color »

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
clarcombe
Premium Member
Premium Member
Posts: 515
Joined: Wed Jun 08, 2005 9:54 am
Location: Europe

Post by clarcombe »

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
Colin Larcombe
-------------------

Certified IBM Infosphere Datastage Developer
Post Reply