DSXchange

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

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.

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.

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.

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.

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

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".

Thank you very much guys