Find Variable in all ETL in project

shrey3a · Post by **shrey3a** » Mon Oct 30, 2006 3:45 pm

Hi Gurus,

We have defined a variable in administrator. Is there is a way to find that in project which all ETL uses that variable.

Regards

samsuf2002 · Post by **samsuf2002** » Mon Oct 30, 2006 4:48 pm

is it something regarding 'Global Environment variable' ???????

Daddy Doma · Post by **Daddy Doma** » Mon Oct 30, 2006 8:36 pm

A dirty solution would be to export your entire project into XML and then do a Search through the text for your variable name. If you are already Generating HTML reports for each job, you can search those. Wherever you find a reference, trawl through the code to find the corresponding job name.

If you need to replace the variable name with a new value; search and replace in a text editor then import back into DataStage. PLEASE, make a backup!

We are (trying) to implement MetaStage on my project but I have only seen it used for job and attribute lineage, not variables.

ray.wurlod · Post by **ray.wurlod** » Mon Oct 30, 2006 8:39 pm

There is no tool, like Usage Analysis, that will do that for you.

If you're prepared to hack the repository, you could interrogate the tables there.

Code: Select all

SELECT DISTINCT DS_JOBS.JOBNAME FMT '32L'
FROM DS_JOBS, DS_JOBOBJECTS
WHERE DS_JOBOBJECTS.OBJNAME = 'ROOT'
AND DS_JOBOBJECTS.OBJTYPE = 'J'
AND DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO
AND DS_JOBOBJECTS.EVAL "@RECORD<14>" LIKE '%<<Variable Name>>%';

kduke · Post by **kduke** » Tue Oct 31, 2006 6:02 am

viewtopic.php?t=99349 might help.