Folder Name

[Shruthi]

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

[ray.wurlod]

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

[chulett]

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