HI- I am trying to find a string like 'PSEUDO' in my whole list of DS jobs.
I need to know about all the transfromations and corresponding job names in which the string is used. Is there any option to do the string search in Datastage?
Thanks
How to find a String in Datastage job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
To search for 'PSEUDO' in each column logic in DS jobs
I wanted to search for word 'PSEUDO' whether it is used in any of the column logic or stage variables logic in all the DS jobs
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Then search an export (DSX) file, or query the DS_JOBOBJECTS table from within the dssh environment. Note that DataStage SQL identifiers are case sensitive.
Code: Select all
SELECT * FROM DS_JOBOBJECTS WHERE EVAL "@RECORD" LIKE '%PSEUDO%';
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.
-
- Participant
- Posts: 35
- Joined: Tue Feb 07, 2012 2:28 am
- Location: China BeiJing