Before job Routine

rajeev_prabhuat · Post by **rajeev_prabhuat** » Mon Dec 13, 2004 5:47 am

Hi,

I want to write an update command on a table in before job routine in ODBC Stage, is this possible. Like in Oracle Enterperise stage there is Before and after SQL queries.

Regards,
Rajeev Prabhu

WoMaWil · Post by **WoMaWil** » Mon Dec 13, 2004 6:33 am

In the actual for DataStage licencend ODBC-Driver a routine including a ODBC-call doesn't work due to licence. So your only chace is a "before-Job"-Job.

Wolfgang

jreddy · Post by **jreddy** » Mon Dec 13, 2004 12:59 pm

If there is a transformer stage before this ODBC stage, then you could wrap up this update SQL in a shell script and call it as an after-stage routine to the transformer stage..
this way it gets done before your SQL in your ODBC starts execution

rajeev_prabhuat · Post by **rajeev_prabhuat** » Mon Dec 13, 2004 9:19 pm

Hi,

Thank you, what you told is correct but I have a doubt in this, if you give it in the after stage routine will it execute for reach row ?.

Regards,
Rajeev Prabhu

jreddy wrote:If there is a transformer stage before this ODBC stage, then you could wrap up this update SQL in a shell script and call it as an after-stage routine to the transformer stage..
this way it gets done before your SQL in your ODBC starts execution

vmcburney · Post by **vmcburney** » Mon Dec 13, 2004 9:51 pm

Switch over to the Dynamic RDBMS stage, it supports ODBC connections and it has Before and After SQL tabs. Much easier then trying to run it through a before-job routine. It's also got a "Treat errors as non-fatal" in case your statement does not work but you don't want it to abort the job.