Error Scenarios

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
e1994264
Premium Member
Premium Member
Posts: 28
Joined: Mon Jul 18, 2011 5:12 pm

Error Scenarios

Post by e1994264 »

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
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

A useful specification, which should allow you easily to implement the job sequence to bring about the required functionality. Well done.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
e1994264
Premium Member
Premium Member
Posts: 28
Joined: Mon Jul 18, 2011 5:12 pm

Hi

Post by e1994264 »

But how to do keep te conditions for that in the job sequence
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply