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
Extract Information of jobs in universe
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.