DSXchange

Can we do exception handling in datastage?
By this I mean can we catch any datastage error and write it into a file.
Say for example if I am creating a file and datastage is not able to create the file due to some reason. In this case instead of datastage job failing I want to capture this error in the same job and write it into a log file.
Is it possible ?

Thanks in advance...

Yes you can. Capture the error log and write to file.

JoshGeorge wrote:Yes you can. Capture the error log and write to file.

How can we do this ?
Can we write user defined messages ?

Check out this link:
http://dsxchange.com/viewtopic.php?p=23 ... ec4#236044


User defined messages takes it to a broader level. You will have to state what all are the expected warning/errors you like to define under this.

khanparwaz wrote:Can we do exception handling in datastage?
By this I mean can we catch any datastage error and write it into a file.
Say for example if I am creating a file and datastage is not able to create the file due to some reason. In this case instead of datastage job failing I want to capture this error in the same job and write it into a log file.
Is it possible ?

No. Most errors of the kind you mentioned are not 'interceptable' and the DataStage job will fail regardless of your desires. And those messages will automatically be written to the log.

JoshGeorge is answering a different question - how to farm error messages from the job's log after it completes.

khanparwaz wrote:Can we do exception handling in datastage?
...

Yes you can. In programatic terms, call all your jobs from a squence and you handle all the job aborts and warnings there.

khanparwaz wrote:Say for example if I am creating a file and datastage is not able to create the file due to some reason. In this case instead of <b>datastage job failing </b> I want to capture this error in the same job and write it into a log file.
Is it possible ?

Well I missed the example What Craig said on that is right.