Page 1 of 1
Before job Routine
Posted: Mon Dec 13, 2004 5:47 am
by rajeev_prabhuat
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
Posted: Mon Dec 13, 2004 6:33 am
by WoMaWil
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
Posted: Mon Dec 13, 2004 12:59 pm
by jreddy
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
Posted: Mon Dec 13, 2004 9:19 pm
by rajeev_prabhuat
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
Posted: Mon Dec 13, 2004 9:51 pm
by vmcburney
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.