DSXchange

Hi,

I want to extract through where clause used in a project all jobs do we have with status running

Thanks in a advance,

Luciana

Not possible.

The status of each job is recorded in a separate table.

Thus for 30 jobs you would need 30 SELECT statements.

Don't do it. There's a perfectly good API available. You still need to cycle through all the job names, but it's easier to do in the API than in DataStage/SQL.

Incidentally, DataStage engine has not been UniVerse since version 5.2.