Posted: Thu Jan 09, 2003 1:38 pm
Well, short answer is to use job parameters as you mentioned in your subject. Create a parameter for every variable you need to pass in to the job. You do that under 'Edit/Job Properties'. Then, anywhere in the transform you want to use the parameter, refer to it enclosed in pound signs (#). As an example:
Parameter name: StartDate
Prompt: Starting Date
Type: Date
You would then refer to #StartDate# in your job. Be sure you match case and be aware that a few places (like in a constraint) you do NOT use the pound signs.
Hope this helps,
-craig
ps. The DataStage tools have (IMHO) excellent online help, so don't forget to check there for information.
Parameter name: StartDate
Prompt: Starting Date
Type: Date
You would then refer to #StartDate# in your job. Be sure you match case and be aware that a few places (like in a constraint) you do NOT use the pound signs.
Hope this helps,
-craig
ps. The DataStage tools have (IMHO) excellent online help, so don't forget to check there for information.