Page 1 of 1
Find out the value for a parameter by Job
Posted: Sun Oct 08, 2006 6:47 am
by Rangs
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 ?
Posted: Sun Oct 08, 2006 6:52 am
by chulett
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.
Posted: Sun Oct 08, 2006 1:45 pm
by ray.wurlod
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?