How to reject invalid records from a sequential file

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
chivl627
Charter Member
Charter Member
Posts: 5
Joined: Fri Oct 14, 2005 10:54 am

How to reject invalid records from a sequential file

Post by chivl627 »

Hi,

I have a staging job which reads from a source sequential file (pipe delimeted) and then loads valid records into a staging table. The problem with the source file is, 2 or 3 records have incomplete number of columns. I want these rows to go to a reject file and only load those valid records in the staging table. Is there a way to filter these bad records? I guess I can use a constraint in the transformer, but what would the constraint be?

Appreciate your help in advance.
Post Reply