Before and After job subroutine
Moderators: chulett, rschirm, roy
Before and After job subroutine
I have a job where i need to run a update statement on table xxx before the job runs and another update statement on table xxx after the job is completed.
I have put the update sttements in Before and After Job-sub routines respectively under the ExecTCL option.but i see a error
Output from UniVerse command was
"Table xxx: does not exist".
But i have that table existing in my schema.
Is this the way i am supposed to do or any other better options to execute these update statements.
Thanks
Sheema
I have put the update sttements in Before and After Job-sub routines respectively under the ExecTCL option.but i see a error
Output from UniVerse command was
"Table xxx: does not exist".
But i have that table existing in my schema.
Is this the way i am supposed to do or any other better options to execute these update statements.
Thanks
Sheema
Are you trying to update a Repository Table? If no then this is not the correct way. Have two jobs to do that. One before this present job in question and one after to do the before after updates respectively.
Last edited by DSguru2B on Mon Jan 22, 2007 11:25 am, edited 1 time in total.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Is this "xxx" a DataStage hashed file accessed as a table or is it in your source/target database? If the latter it would explain why you are getting this error message.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
You need to use the before/after SQL tabs in your OCI stage. The before/after routine calls allow you to either run DataStage engine commands (ExecTCL) or operating system commands (ExecSH/ExecDOS) or custom written routines.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle