Search for a string in SYSTEM TABLES

[poorna_76]

Hi All,

For searching a particular string in SYSTEM TABLES, currently i am using this query (i think KimDuke posted this query some time back)

************
SELECT
DS_JOBS.NAME AS JOB_NAME,
DS_JOBS.CATEGORY,
DS_JOBOBJECTS.NAME AS OBJECT_NAME,
DS_JOBOBJECTS.OLETYPE,
EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),'#parmSearchString#',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L'
FROM
DS_JOBS,
DS_JOBOBJECTS
WHERE
DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO
and FOUND = 'FOUND'

GROUP BY
JOB_NAME,
DS_JOBS.CATEGORY,
OBJECT_NAME,
DS_JOBOBJECTS.OLETYPE,
FOUND
;
**********
How would i display the whole expression, where a particular string we are searching for ,is found?

Thanks in Advance.

[kduke]

viewtopic.php?t=99543

[kduke]

This script is called DsSearch1.sql. It is part of EtlStats.