In my datastage project the parameter called ErrorNumber is common across all Jobs. This parameter carries a defualt value for each job. Is there a way of querying the DataStage repository to list all Jobs with corresponding deafult value for this parameter ??
Please let me know how and what query to use. WHat stage to use ?
Find out the value for a parameter by Job
Moderators: chulett, rschirm, roy
Querying the repository doesn't require a stage. You can either do it from a TCL session initiated from the command line on your server or from the Administrator client.
Again, I'd suggest a thorough search of the site. There are many examples of DS_JOBOBJECTS queries here and with a little work on your part you should be able to get what you are looking for.
Again, I'd suggest a thorough search of the site. There are many examples of DS_JOBOBJECTS queries here and with a little work on your part you should be able to get what you are looking for.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Run-time parameter values are in the RT_CONFIGxxx hashed files. They are also reported in the job log "job starting" event.
Every parameter has two default values; the design-time default, created when the job is designed, and the run-time default, which is set using the Set Defaults utility in the Director client. Which of these were you wanting?
Every parameter has two default values; the design-time default, created when the job is designed, and the run-time default, which is set using the Set Defaults utility in the Director client. Which of these were you wanting?
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.