How to can we get the details of a stage via unix
Moderators: chulett, rschirm, roy
How to can we get the details of a stage via unix
Hi All ,
I want to know how we can get the stage names via unix commands .
I tried dsjob -lstages <project> <JobName>
But it is not providing exact info .
For eg it is not providing the oracle stage info .
Is there any other way to identify the same ?
I want to know how we can get the stage names via unix commands .
I tried dsjob -lstages <project> <JobName>
But it is not providing exact info .
For eg it is not providing the oracle stage info .
Is there any other way to identify the same ?
I have four stages .
Source is Oracle stage.From oracle stage we are loading the data into a hash file and from there via transformer into target table which is again a oracle table .
But when I fire this command it is not providing the source oracle info .
And for hash file it is giving with ".IDENT" extension .
Source is Oracle stage.From oracle stage we are loading the data into a hash file and from there via transformer into target table which is again a oracle table .
But when I fire this command it is not providing the source oracle info .
And for hash file it is giving with ".IDENT" extension .
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Read about DSGetJobInfo() in the DataStage BASIC manual. There are different options to return different sets of stages; the default gives only the active stages. The dsjob -lstages command gives effect to this default. You can always modify the dsjob code.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
SELECT NAME FROM DS_JOBOBJECTS WHERE OBJNAME LIKE 'V%S%' AND OBJNAME NOT LIKE 'V%S%P%' AND OBJIDNO = (SELECT JOBNO FROM DS_JOBS WHERE NAME = '<<JobName>>');
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.