DSXchange

How to set up a job to abort based on a particular value of a column?

Why abort? Why not capture it and move on?

chulett wrote:Why abort? Why not capture it and move on? ...

no abort only

say source has name column. as soon as name value = "xyz" , it should abort.

is it doable using triggers?

I don't believe in causing jobs to abort. I feel it is far better to retain control over what is happening.

That said, there are several solutions, including limiting the number of rows on an output link from a Transformer stage that might handle this particular value, or conditionally calling a routine that invokes DSLogFatal() function.

And I prefer to capture them all and then conditionally abort the job if the error file is not empty and that is the requirement. That way all problems are known, not just the first one.

Database triggers? A 'before insert' trigger that raises an error when that value is seen could work, I suppose, depending on your warning level. Or you could just call DSLogFatal() in the job itself.

chulett wrote:Database triggers? A 'before insert' trigger that raises an error when that value is seen could work, I suppose, depending on your warning level. Or you could just call DSLogFatal() in the job itself. ...

Thanks Craig!!!

Where can I find full documentation for all the functions like DsLogFatal or other DS routines, procedures ?

At Version 8 look into the "Programmer's Guide" to find those routines documented.

Or the "online" help from the client tools. Switch to the Index tab, type "DS" and you'll be right there.

ArndW wrote:At Version 8 look into the "Programmer's Guide" to find those routines documented. ...

Hi ,

Can you please tell me where would I get "Programmer's Guide"? I looked into online documentation available but didn't find it there.

Go into your Programs -> IBM Information Server -> Documentation and, from the list, choose your appropriate language for "Programmer's Guide" in the "Websphere DataStage" section.