aborting a job

agpt · Post by **agpt** » Sun Oct 03, 2010 11:04 am

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

chulett · Post by **chulett** » Sun Oct 03, 2010 11:41 am

Why abort? Why not capture it and move on?

agpt · Post by **agpt** » Sun Oct 03, 2010 11:47 am

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.

agpt · Post by **agpt** » Sun Oct 03, 2010 11:48 am

is it doable using triggers?

ray.wurlod · Post by **ray.wurlod** » Sun Oct 03, 2010 12:23 pm

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.

chulett · Post by **chulett** » Sun Oct 03, 2010 2:52 pm

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.

chulett · Post by **chulett** » Sun Oct 03, 2010 2:55 pm

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.

agpt · Post by **agpt** » Mon Oct 04, 2010 5:29 am

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 ?

ArndW · Post by **ArndW** » Mon Oct 04, 2010 5:59 am

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

chulett · Post by **chulett** » Mon Oct 04, 2010 6:55 am

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

agpt · Post by **agpt** » Mon Oct 04, 2010 9:41 am

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.

ArndW · Post by **ArndW** » Tue Oct 05, 2010 2:47 am

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.