How can I retrieve details for a jobs by using Universe BASIC?
Say I need to collect stage variables & its derivations within job & write those to some file in a Unix directory.
Retrieving job details using UniVerse BASIC.
Moderators: chulett, rschirm, roy
Retrieving job details using UniVerse BASIC.
Thanks with regards,
videsh.
videsh.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
DSGetStageInfo(hJob, StageName, DSJ.STAGEVARLIST) will return a list of the stage variable names.
The derivation of a stage variable is not part of the retrievable information using these functions, since it's design-time information only. You would need to recover them from DS_JOBOBJECTS, in which you would need to find the correct stage record then within that to unpack the collection of stage variables (which begins at the CStageVar marker).
Not a job for the faint hearted! Why do you want to do this? Do not the existing documentation tools provide what you require?
The derivation of a stage variable is not part of the retrievable information using these functions, since it's design-time information only. You would need to recover them from DS_JOBOBJECTS, in which you would need to find the correct stage record then within that to unpack the collection of stage variables (which begins at the CStageVar marker).
Not a job for the faint hearted! Why do you want to do this? Do not the existing documentation tools provide what you require?
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.
We have lengthy derivations within StageVars. It becomes difficult to track syntax or logical errors within this small window.
I was wondering if I can take out these derivations within transformer taken out to some sequential file. Task of reviewing those will be simpler.
I was wondering if I can take out these derivations within transformer taken out to some sequential file. Task of reviewing those will be simpler.
Thanks with regards,
videsh.
videsh.
Do a search for GenHtml. This is a series of jobs which extract this information into HTML documents. It is easy to cut and paste from these documents into whatever you like. The Reporting Assistant included with DataStage in the Manager will also extract this information into Access database named doc_tool.mdb. DwNav can be used to view this. If you want I can look up how stage variables are stored in these tables.
Mamu Kim
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If you're using 7.5 click on the icon on the toolbar that looks like Internet Explorer's icon. This will generate full documentation for the job design, including all derivations.
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.