Hi,
Please help me with this below requirement.
Is that possible for me to run commands in command page of administrator and identify a job which uses a particular table name?
ex: if a table EMP_NO is used in one job employee_test, can i find this job name employee_test by running a command in Admin, i have huge list of jobs and manually searching it takes a lot of time for me, i tried using command LIST DS_JOBS which gave me all the jobs in a particular project, i am not aware of teh syntax to use to find solution for my above requirement. please help.
Thanks.
Running Commands in DS Administrator
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
SELECT NAME FMT '32L', CATEGORY FMT '32L' FROM DS_JOBS
WHERE JOBNO IN
(SELECT OBJIDNO FROM DS_JOBOBJECTS
WHERE EVAL "@RECORD" LIKE '%EMP_NO%');
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.