Hi everyone,
i'm writing a job to get all the instances and jobs logs from the project.
Can i get somewhere the job folder seen in the director using a Datastage Basic function ?
Thank you
Carlos.
Repository structure folders on a routine
Moderators: chulett, rschirm, roy
Others may know more better than me on the DSGetJobInfo() thing as I can't test as I have no DataStage access. I do seem to recall that the command line dsjob version does include that information but you don't really want to be shelling out to the O/S on every row. Otherwise a lookup to a Universe or Hashed File stage should do the trick. Basically:
SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'YourJobName'
SELECT CATEGORY FROM DS_JOBS WHERE NAME = 'YourJobName'
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
I believe that there isn't a DSGetJobInfo() code which will return the category. I have always retrieved this information by reading the DSJOBS file and parsing the category out of that.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Code: Select all
Trans("DS_JOBS", vJdName, 3, "X")
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.