Getting category list in a project

[tom]

Hi folks,

Can anybody tell me how to get list of category names in a project from command prompt. I mean for list of projects "dsjob -lprojects" and for list of jobs "dsjob -ljobs". In the same way is there any option to get list of categories in a project.

Please suggest me

Thanks in advance.

[jhmckeever]

Unfortunately there isn't a "dsjobs -lcategories" option. An easier solution, however, is to use a UV query on the repository:

Code: Select all

SELECT DISTINCT CATEGORY FMT 60 FROM DS_JOBS;

From your project directory you can execute it straight from the command line:

Code: Select all

uv "SELECT DISTINCT CATEGORY FMT 60 FROM DS_JOBS;"

HTH,
J.

[ray.wurlod]

Do you want just job categories, or routine, table definition and other categories as well? If the latter, simply execute similar commands on the other Repository tables and form the UNION. For example

Code: Select all

SELECT DISTINCT 'Jobs',CATEGORY FMT '60L' FROM DS_JOBS
UNION
SELECT DISTINCT 'Routines',CATEGORY FROM DS_ROUTINES;

[tom]

Hi,

I tried uv ""SELECT DISTINCT CATEGORY FMT 60 FROM DS_JOBS;" from the project directory from command prompt. But i got "Command Not Found". Can u please suggest me

[DSguru2B]

You need to set your dsenv first. Search on how to execute dsenv file. Then run that command. Or simply log onto your DataStage Administrator and run the commad

Code: Select all

SELECT DISTINCT CATEGORY FMT 60 FROM DS_JOBS;

in the command area. Dont forget the trailing semicolon.

[ray.wurlod]

You need to set your PATH to include $DSHOME/bin or to specify the full pathname of the uv command.

After that, you may find that you have not executed the dsenv script, which will cause errors about libraries when you manage to execute the uv command.