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
Find Variable in all ETL in project
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 397
- Joined: Wed Apr 12, 2006 2:28 pm
- Location: Tennesse
-
- Premium Member
- Posts: 62
- Joined: Tue Jun 14, 2005 7:17 pm
- Location: Australia
- Contact:
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.
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.
When you know that you are destined for greatness by virtue of your mutant heritage it is difficult to apply yourself to normal life. Why waste the effort when you know that your potential is so tremendous?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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>>%';
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.