Fpt stage is reading the extra null record from the soure

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
eze_ke
Participant
Posts: 38
Joined: Wed Mar 30, 2005 11:42 am

Fpt stage is reading the extra null record from the soure

Post by eze_ke »

Hi,

I'm using the ftp stage in most of the jobs.
In couple of jobs FTP stage is reading an extra records. which is null records.
I want to know why it is reading a null record.
If my src has 100 records then FTP stage is readin 101 records and one is is null record.
Please suggest me how to solve this proble.
I'm getting warning in the DS job for the above problem.

Thanks in Advance
Eze_ke
ray.wurlod
Participant
Posts: 54595
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

It's probably an extra line termination character at the end of the file.
If you can't change the file, handle it with a rejects link and/or create a message handler to demote the warning to an informational message.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply