Page 1 of 1
How to find a String in Datastage job
Posted: Wed Jan 23, 2013 12:24 pm
by deepag
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
Posted: Wed Jan 23, 2013 1:13 pm
by ray.wurlod
Use Quick Find and search for *PSEUDO*
To search for 'PSEUDO' in each column logic in DS jobs
Posted: Wed Jan 23, 2013 4:22 pm
by deepag
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
Posted: Wed Jan 23, 2013 7:20 pm
by ray.wurlod
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%';
Posted: Fri Jan 25, 2013 1:29 am
by dongyingying
I agree with ray