DSXchange

One of the Px jobs fails reporting a fatal error : parallel job reports failure(code1). When do we get such an error and what are the possible reasons? The job reads from a sequential file, does DB2 lookups and output to DB2.

Thanks for your response Rich. We checked the jobs again and but did not find the descrepencies you have mentioned

1. Nullablity of the column is set to 'NO' everywhere in the first job.
2. Metadata in both jobs is same with Nullablity of the column set to 'NO'.

Any other ideas or suggestions?

We are writing to a Dataset from job1, but we are not able to read from it in job2. We get a message "Null value in <field> which is not null". When we make the nullability of the column to 'Yes', it fetches data, however there are no null values in this date field. Another interesting thi...