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.
file search
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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%');
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.