Capture Fatal error message

ADIRBK2010 · Post by **ADIRBK2010** » Sun Jan 04, 2015 5:09 pm

Hi,

I am looking for a better approach to solve this.

my job needs to test connectivity of databases . We have designed a job which would connect to a single database and runs a small query.
When our the parallel jobs completes we are writing the status a success to a report file and if the job Parallel job aborts we are writing status as failure. This runs in a loop for all databases.

My sequencer is restartable .

now my requirement is to add the fatal error message as part of the report file when ever the parallel job aborts.

what could be a best approach.

Thanks
RP

ArndW · Post by **ArndW** » Mon Jan 05, 2015 1:57 am

The reject link coming out of your database connector can have the SQL code as a field, which you can then use to write to an error table.

vibwipro · Post by **vibwipro** » Mon Jan 05, 2015 10:26 am

Hi

You Can Write a Small Server routine using "DSRunJob" command which will fetch last run Job Status and based on status you can write Message in Status Report. This routine will be embeded in Loop it self only.

ADIRBK2010 · Post by **ADIRBK2010** » Mon Jan 05, 2015 12:30 pm

I cannot use a Reject link for a source connector . It throws a compile time error.

IBM documentations says that its known issue that it allows to create a reject link in designer but cannot compile the same.

chulett · Post by **chulett** » Mon Jan 05, 2015 2:25 pm

You probably need to look at pulling it from the job's log using the API (the various DSGetLog* functions) depending on exactly what 'fatal error message' you are looking for.

ADIRBK2010 · Post by **ADIRBK2010** » Wed Jan 14, 2015 10:39 pm

I am new to Datastage and unable to write a routine in simple steps.

None of the links are giving a valid response on google.

I am not sure in which language/script the DS routines are written atleast to refer sample routines.

Someone gave a link to regularly used routines and the link is already expired.

I am not able to move ahead. Need some help

chulett · Post by **chulett** » Thu Jan 15, 2015 12:20 am

DataStage routines are written in BASIC. From what I recall, all of the routines that ship with the product include their source code which you can examine as a great learning tool. Can you clarify for us exactly what 'fatal error message' you are after, is it in fact any from the job's log that you are after, the one you've said is to test connectivity?

If so, here's a couple of posts that may help:

viewtopic.php?t=151401

viewtopic.php?t=148423

There should be plenty of others, all I did to find these was an exact search here for "dsgetlog".

ADIRBK2010 · Post by **ADIRBK2010** » Mon Mar 02, 2015 6:53 pm

Thank you very much guys

DSXchange

Capture Fatal error message

Capture Fatal error message

Re: Capture Fatal error message