Hi ,
could you please any one clarify me where i need to find out UV Tables information( means table information)
UV Tables
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Moderator: please move to Server forum
Moved. I'm thinking it should really go in General since this topic applies to both products but since I've added notes about Server job access, we'll go where you bid.![Wink :wink:](./images/smilies/icon_wink.gif)
Moved. I'm thinking it should really go in General since this topic applies to both products but since I've added notes about Server job access, we'll go where you bid.
![Wink :wink:](./images/smilies/icon_wink.gif)
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.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
The second table would actually be DS_JOBOBJECTS and in addition to simply querying them, you could also use LIST.DICT to see their structure. But, as noted, they are not officially documented.
You could also use those tables in a Server job via the UV stage set either to localuv or by specifying a project / account name at runtime, typically via a job parameter.
You could also use those tables in a Server job via the UV stage set either to localuv or by specifying a project / account name at runtime, typically via a job parameter.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
You have to trick DataStage into giving you the metadata for these tables. You need to create q-pointers. The VOC entry looks like this for DsJobs.
Q
<blank>
DS_JOBS
Where <blank> is an empty string. If you create with the ED command then put ; in there and replace ; with null. like c/;//.
There are lots of posts on q-pointers. RT_LOGnnn is another useful hashed file. EtlStats has lots of jobs which extract information from these tables. All of this is unsupported and may not work in the next release of DataStage. So be careful. API calls are a lot safer.
Q
<blank>
DS_JOBS
Where <blank> is an empty string. If you create with the ED command then put ; in there and replace ; with null. like c/;//.
There are lots of posts on q-pointers. RT_LOGnnn is another useful hashed file. EtlStats has lots of jobs which extract information from these tables. All of this is unsupported and may not work in the next release of DataStage. So be careful. API calls are a lot safer.
Mamu Kim