Hi,
Can I edit the default values of the job parameters. if so how?
which views to query for viewing the default values?
Default value
Moderators: chulett, rschirm, roy
Default value
Regards
Srinivas
Srinivas
Theoreticly it can be done but you have to have a very deep internal knowledge of what you do.
The best way to reach what you want to reach is:
Write sequences or (if you prefer it the unix way) shell scripts for to start the DataStage-Jobs. There you can feed any parameter at runtime which you want.
You should devide parameters in three groups.
Development-Step-Parameters:
that are parameters, which differ with the development-step and which are different in devellopment, test, integration or production for example a DB-User and a DB-Pasword
Run-Step-Parameters:
that are parameters which differ with each run of a job, for example a filename, which has each month a different name because the date is included in the filename.
General Parameters:
that are parameters which remain the same within each job but may differ for special purposes
It is better to nourish every job start with the correct parameters than to change the default values. Default values are helpful for the development process.
The best way to reach what you want to reach is:
Write sequences or (if you prefer it the unix way) shell scripts for to start the DataStage-Jobs. There you can feed any parameter at runtime which you want.
You should devide parameters in three groups.
Development-Step-Parameters:
that are parameters, which differ with the development-step and which are different in devellopment, test, integration or production for example a DB-User and a DB-Pasword
Run-Step-Parameters:
that are parameters which differ with each run of a job, for example a filename, which has each month a different name because the date is included in the filename.
General Parameters:
that are parameters which remain the same within each job but may differ for special purposes
It is better to nourish every job start with the correct parameters than to change the default values. Default values are helpful for the development process.
Wolfgang Hürter
Amsterdam
Amsterdam
Another option of the 'brute force' variety for a global / mass change of default values is the old 'export / edit / import' techinique. Perform a full export of the job's source then edit the .dsx, doing a search and replace of the values. Lastly reimport and recompile. Not all that elegant, but does work.
You can also get access to Kenneth Bland's website, one of his many free utilities is a batch job that does this.
You can also get access to Kenneth Bland's website, one of his many free utilities is a batch job that does this.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Best answer is to build some form of 'job control' that negates the need to worry about default values across projects. A central store of some kind where parameter values are automatically assigned at runtime is what is typically implimented.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers