How to find a String in Datastage job

[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

[ray.wurlod]

Use Quick Find and search for *PSEUDO*

[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

[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%';

[dongyingying]

I agree with ray