OSH file Information
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 9
- Joined: Sat Oct 10, 2009 6:13 am
OSH file Information
As we know when datastage job executes it creates a Orchestrate file. Suppose i have an Orchestrate file then how can i know relevant job regarding Orchestrate file..
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The osh script generated by a parallel job being compiled is in a directory called RT_SCnnn. Here, nnn is the job number, which is mapped to the job name via the DS_JOBS table.
Note that JOBNO is a VarChar, so single quotes are needed.
The osh script generated by a parallel job being compiled contains a comment at line 1 indicating which job was compiled and the date and time that that occurred.
Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBNO = 'nnn';
The osh script generated by a parallel job being compiled contains a comment at line 1 indicating which job was compiled and the date and time that that occurred.
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.