file search

[koolsun85]

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.

[kumar_s]

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

[koolsun85]

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

[ray.wurlod]

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