Hi,
I want to create a batch file. The batch file should 1st call the datastage job. Once the job is successful it should call the stored procedure.
Can you please provide me the procedure to write them? In datastage director i have an option to create a batch. can i use them or should i write a code to create batch file?
Thanks
batch file creation
Moderators: chulett, rschirm, roy
Do you wish to create a sequence in DataStage to start the job and then call a stored procedure, or do you wish to write a Windows .bat batch file to start the job then call a stored procedure?
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Version 4 does not have job sequences. You would need to do this using a job control routine. And - I believe - you'll need to construct a script to call the stored procedure unless it deals with a record set, in which case you can use an ODBC stage.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
batch file creation
ArndW wrote:Do you wish to create a sequence in DataStage to start the job and then call a stored procedure, or do you wish to write a Windows .bat batch file to start the job then call a stored procedure?
Hi Arndw,
I want to create a windows .bat batch file to run the job and then to run the stored procedure. Do you have any suggestions? Datastage 4.2 does not have sequencer.
Thanks
batch file creation
ArndW wrote:Do you wish to create a sequence in DataStage to start the job and then call a stored procedure, or do you wish to write a Windows .bat batch file to start the job then call a stored procedure?
Hi Arndw,
I want to create a windows .bat batch file to run the job and then to run the stored procedure. Do you have any suggestions? Datastage 4.2 does not have sequencer.
Thanks
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: