Hi,
Is there a way to find a folder name given the job name. I have list of jobs, I want to find in which folder (Datastage designer), they reside?
Thanks
Folder Name
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's called the category, and CATEGORY is a field in the DS_JOBS table.
Code: Select all
SELECT NAME, CATEGORY FROM DS_JOBS WHERE NAME IN ('JobName1', 'JobName2', 'JobName3');
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.