DSXchange

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.

Unfortunately there isn't a "dsjobs -lcategories" option. An easier solution, however, is to use a UV query on the repository:
From your project directory you can execute it straight from the command line:
HTH,
J.

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

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

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 in the command area. Dont forget the trailing semicolon.

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.