Hi folks,
Where the job parameters pertaining to a job are stored in the datastage universe.
e.g. all the job names stored in table DS_JOBS.
Where the job paramters stored in the unverse
Moderators: chulett, rschirm, roy
Job parameters are not stored as such in the engine. The default values are stored within the job metadata, but the actual values used at runtime are only accessible by using the API routines such as DSGetParamInfo().
<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:
Of course they are stored, but in a number of places. Job parameters have design-time default values, run-time default values (set in Director), indirect default values (for environment variable job parameters), and, of course, the values with which the job was last run. All of these things are stored in different locations, indeed mostly in different tables.
None of this location information has been published by the vendor. Indeed it has deliberately not been published, and they reserve the right to change it at any time. And have done in previous versions.
None of this location information has been published by the vendor. Indeed it has deliberately not been published, and they reserve the right to change it at any time. And have done in previous versions.
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:
Only earlier as far as version 5.0 - it's a different structure earlier than that. Version 8.x it's different again. Further, some of the things I referred to above are stored in RT_CONFIGnnn.
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.
Thanx for your prompt replyArndW wrote:Job parameters are not stored as such in the engine. The default values are stored within the job metadata, but the actual values used at runtime are only accessible by using the API routines such as ...
Where exactly The default values are stored within the "job metadata"(in which table)
Rhaddur
rhaddur,
Job parameters defined in a Job are stored in the ROOT record of UniVerse table DS_JOBOBJECTS in version 7 and earlier versions as Kduke said. Here are position numbers(Field No) in DS_JOBOBJECTS file for each element in Job parameter properties.
And moreover you can use the below UniVerse SQL to fetch the Job Parameter defined in a Job but mind - the result would be of multivalued columns So you would get only one record no matter how many Job Parameter defined in a Job.
And I am pretty sure that you can get a lot more Jobs related to Job Parameters Extract from UniVerse tables, from kduke's creation 'ETLStats' at his site.
Very useful tool in extracting medata of DS Jobs and much more.
Job parameters defined in a Job are stored in the ROOT record of UniVerse table DS_JOBOBJECTS in version 7 and earlier versions as Kduke said. Here are position numbers(Field No) in DS_JOBOBJECTS file for each element in Job parameter properties.
Code: Select all
Parameter Name - 14
Prompt - 16
Type - 19
Default Value - 17
Help Text - 18
Code: Select all
SELECT
EVAL DS_JOBOBJECTS."@RECORD<14>" AS Param_Name,
EVAL DS_JOBOBJECTS."@RECORD<16>" AS Prompt,
EVAL DS_JOBOBJECTS."@RECORD<19>" AS Type,
EVAL DS_JOBOBJECTS."@RECORD<17>" AS Default_Value,
EVAL DS_JOBOBJECTS."@RECORD<18>" AS Help_Text
FROM
DS_JOBOBJECTS , DS_JOBS
WHERE
DS_JOBOBJECTS.OLETYPE='CJobDefn' AND DS_JOBS.JOBNO=DS_JOBOBJECTS.OBJIDNO AND DS_JOBS.NAME='<jobName>';
Very useful tool in extracting medata of DS Jobs and much more.