DSXchange

Hi Guys,

How to find total no.of jobs from my project using datastage administrator

or command line mode.

Thanks in advance.

Thanks
Narasa

If you mean the UniVerse/DataStage environment command line mode, you can execute COUNT DS_JOBS WITH JOBTYPEIND NE ''

If you mean Unix, you could do a "dsjob -ljobs {yourprojectname} | wc -l"

would be my preference from the Administrator client command window.

Hi ray,

COUNT DS_JOBS WITH NAME LIKE "1A0X"

"1A0X" --> What does it mean?


could you Explain!

In the BASIC Programmer's Guide pages 6-248 onwards it describes the mask formats - this one denote 1 alphabetic character and then any number of any characters. The reason you cannot just do a COUNT of the file is that it contains several records that do not hold descriptions of jobs but control information and we are filtering them out.

Note that the dsjob command will also return the status code.

The DS_JOBS table has categories in it as well as jobs. They start with "\". So to not count them you need to do what Ray posted or something similar. I prefer UNLIKE "\...". This is just Ray's style.