Problem with Sequential File Stage - No Metadata Rejects

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
moalik
Participant
Posts: 39
Joined: Thu Sep 15, 2011 8:15 am
Location: Melbourne

Problem with Sequential File Stage - No Metadata Rejects

Post by moalik »

Hi All,

I am passing a Comma Separated File as my Input to a sequential file. In the properties, I am enabled the "Reject Property = Output".

My Input Data:
Col1(Not Nullable), Col2(Not Nullable), Col3 (Nullable)
,a,b
,,c
a,b,c
a,,c

When I am running the job instead of rejecting 3 records, it is treating as the valid records.

Could you please let me know, if I am missing anything.
Mohsin Khan
Datastage Consultant
qt_ky
Premium Member
Premium Member
Posts: 2895
Joined: Wed Aug 03, 2011 6:16 am
Location: USA

Post by qt_ky »

The reject link will catch more severe metadata mismatches, such as records that are missing columns.

In your example, the job will most likely take your empty strings as empty strings, which are different than the NULL value. In some cases, the job will substitute in the default value for the column.
Choose a job you love, and you will never have to work a day in your life. - Confucius
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Assuming that all three columns are defined as VarChar, there is nothing wrong with your data from a metadata perspective.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
moalik
Participant
Posts: 39
Joined: Thu Sep 15, 2011 8:15 am
Location: Melbourne

Post by moalik »

Thanks Ray and qt_ky for the prompt replies.
Mohsin Khan
Datastage Consultant
Post Reply