OSH file Information

ashish10mca · Post by **ashish10mca** » Fri Oct 29, 2010 4:51 am

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..

ArndW · Post by **ArndW** » Fri Oct 29, 2010 6:29 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Oct 29, 2010 11:44 am

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.