DSXchange

Posted: **Wed May 04, 2011 11:21 pm**

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

Posted: **Thu May 05, 2011 12:27 am**

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

Posted: **Thu May 05, 2011 6:29 am**

Run that from a TCL prompt at the command line or from the Administrator client.

DSXchange

Folder Name

Folder Name