finding unix shell scripts used in datastage

Maximus_Jack · Post by **Maximus_Jack** » Mon Feb 27, 2012 10:44 am

Hi
we have a project which has more than 450 jobs, i need to find which jobs are using a shell script inside them, mostly all the unix scripts are called from the external source stage and all the scripts ends with ".sh" extension, so is there
any easy way to find the names of those scripts.

cheers
max

ray.wurlod · Post by **ray.wurlod** » Mon Feb 27, 2012 1:42 pm

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%.sh%');

Maximus_Jack · Post by **Maximus_Jack** » Wed Feb 29, 2012 10:58 am

thanks ray, i googled and tried in this site as well, but couldnt find any substantial documents regarding the datastage tables (ds_jobs, etc), is there
anywhere i can find one? and one more question, in what database these tables are constructed?

cheers
karthy

ray.wurlod · Post by **ray.wurlod** » Wed Feb 29, 2012 3:01 pm

There's no public domain documentation. These tables were originally built using the UniVerse RDBMS (the original engine for DataStage). When IBM purchased UniVerse but had not yet purchased DataStage, the two engines shared the same code base, and have diverged only a little since. UniVerse RDBMS is now owned and marketed by Rocket Software.

_Mike · Post by **_Mike** » Thu Mar 01, 2012 8:00 am

thanks ray, so is there any way to learn about these things?

ray.wurlod · Post by **ray.wurlod** » Thu Mar 01, 2012 2:40 pm

Not really. I come from a UniVerse background, so that helps. I worked for the vendor who created DataStage, which helped a lot. It has always been the vendors' decision not to publish details of the underlying engine databases.

Maximus_Jack · Post by **Maximus_Jack** » Fri Mar 02, 2012 10:22 am

why dont you write some paper on this

thanks ray.. for your response..

ray.wurlod · Post by **ray.wurlod** » Fri Mar 02, 2012 2:27 pm

Time poor, plus anything I write belongs to my employer, so there's no financial incentive either.

vamsi.4a6 · Post by **vamsi.4a6** » Sat Oct 13, 2012 11:03 am

ray.wurlod wrote:

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO IN (SELECT OBJIDNO FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%.sh%');

...

Could You please clarify what is meant by EVAL and @RECORD in the above query?

ray.wurlod · Post by **ray.wurlod** » Sat Oct 13, 2012 3:19 pm

EVAL introduces an in-line expression.
@RECORD is a system variable that contains the entire record as a single delimited string.