DSXchange

Hi forumers ....

With the next UNIX command obtain the number of jobs:

> dsjob -ljobs MyProject | wc -l

But the result is only the server jobs ...

How obtain the total number of jobs in my project (server and mainframe) ?????

COUNT DS_JOBS WITH @ID LIKE "1N0N"

This UniVerse (DataStage Engine) command counts the integer keys in the DS_JOBS file. This is the total number of jobs that you have. It does not differentiate job type; this was not part of your original request.

To execute this from a UNIX shell, you need the uv command.
cd yourproject
$DSHOME/bin/uv "COUNT DS_JOBS WITH @ID LIKE '1N0N'"

I do not know or use what Ray posted, but this too will work -

>SELECT DS_JOBS <> '\\NextNumber' AND F5 > 0

This will not include the Next Number record and only those objects that have a job number. Folders do not have a job number.

Regards,

Michael Hester