DSXchange

Posted: **Tue Aug 10, 2010 3:44 pm**

Hello everyone,
I have a mainframes file as "sample.dat "
I need to know the jobs which uses this particular file.
Need a command in ds admin for this search.

Thanks in advance.

Posted: **Tue Aug 10, 2010 3:55 pm**

If you have stored the metadata you can search and locate it from Repositry with the help of Usage Analysis itself.

Posted: **Tue Aug 10, 2010 4:31 pm**

If it is stored before then we can...
But if it is not stored previously then how can we search through command line.

Posted: **Tue Aug 10, 2010 5:17 pm**

Code: Select all

SELECT NAME FROM DS_JOBS WHERE JOBNO IN (SELECT DISTINCT OBJIDNO FROM DS_JOBOBJECTS WHERE OLETYPE LIKE '%put' AND EVAL "@RECORD" LIKE '%sample.dat%');

DSXchange

file search

file search