DSXchange

Hi, I have the error handling things in Datastage Jobs. When we we create sequencer it should throw errors and insert into the table
These are the following situations when it find error
1.Source File Not Found
Action : Error record should be generated And inserted into a table/
2.Database connection error
Action: Error record should be generated And inserted into a table
3.Zero byte file received(source file)
Action:Error record should be generated And inserted into a table

A useful specification, which should allow you easily to implement the job sequence to bring about the required functionality. Well done.

But how to do keep te conditions for that in the job sequence

Any way you like.

For example, to test for the existence of a file use an Execute Command activity to execute the test command and test its exit status (via the appropriate activity variable for the activity).