Page 1 of 1
OSH file Information
Posted: Fri Oct 29, 2010 4:51 am
by ashish10mca
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..
Posted: Fri Oct 29, 2010 6:29 am
by ArndW
This is a one-way route, one needs to reach the OSH script in order to get an idea of what the job looks like. The OSH scripts pre-date the graphical front end.
Posted: Fri Oct 29, 2010 11:44 am
by ray.wurlod
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.
Code: Select all
SELECT NAME FROM DS_JOBS WHERE JOBNO = 'nnn';
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.