Project Name and Categories

[hexa]

Hello,

How can I get the names of all the Projects in DataStage?

Also How can I get the names of all the Categories in a project?


Hexa

[Kirtikumar]

To get the project list:
From director select Project--> Open menu and list of projects will be displayed.

To get the category details, cant say
But you may need to log onto each project and then get the list.

[Sunshine2323]

For Projects:

dsjob -lprojects

For Categories:

select DISTINCT(CATEGORY) from DS_JOBS;

Hope this helps

Sunshine