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.
Problem with Sequential File Stage - No Metadata Rejects
Moderators: chulett, rschirm, roy
Problem with Sequential File Stage - No Metadata Rejects
Mohsin Khan
Datastage Consultant
Datastage Consultant
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.
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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: