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
Before job Routine
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 136
- Joined: Wed Sep 29, 2004 5:56 am
- Location: Chennai
- Contact:
-
- Participant
- Posts: 136
- Joined: Wed Sep 29, 2004 5:56 am
- Location: Chennai
- Contact:
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
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
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn