Page 1 of 1
Environment Variables are not refreshing in JOB
Posted: Thu Sep 27, 2007 8:43 pm
by ramaiahn
Hi All,
I have created 1 User Defined Environment variable p_Created_BY and given the value as 7 using Data Stage Administrator.
Later i have added these variable to JOb in Designer. Its working Fine.
Problem:
I have changed the value of the Variable p_Created_BY to 10 in Adminstrator.
But the changed value is not reflecting in the JOB and showing the old value as 7.
Hope you people understood my problem.
Can pls help to solve this problem very urgently.
Thanks in Advance to all
Regards
Ramaiah
Posted: Thu Sep 27, 2007 9:02 pm
by ray.wurlod
Etiquette Note
We do not do "urgent" here, much less "very urgently". People who post here are all volunteers, who post as and when they can. If you require urgent support, sign up for premium service with your support provider, and learn the true cost of "urgent".
What is the default value of the job parameter within your job design?
To automatically pick up what you set in the Administrator client, the default value of the job parameter must be the special token $PROJDEF
Posted: Thu Sep 27, 2007 9:39 pm
by chulett
What exact 7.x version? Versions earlier than 7.5.x did not work properly in that regard, needing jobs to be recompiled to recognize a change from what I remember.
Posted: Thu Sep 27, 2007 10:24 pm
by ramaiahn
Using Data Stage Standard Version 7.5.2
Thanks
Ramaiah
Posted: Thu Sep 27, 2007 10:49 pm
by chulett
Then there's no bug to worry about. Explain exactly how you 'added these variable' and what the default value is in the job... $PROJDEF?
Posted: Thu Sep 27, 2007 11:13 pm
by ramaiahn
I have defiened the User defined variable in Administrator and assigned the value as 2.
Later i have modified the same variable value to 4 in Adminstrator. But this value is not reflected in Data Stage Server Job.
Thanks
Ramaiah
Posted: Thu Sep 27, 2007 11:49 pm
by chulett
Please answer the question that was asked. What is the default value of this parameter in the job... $PROJDEF?
Posted: Fri Sep 28, 2007 12:11 am
by ramaiahn
I really dont know how to get the value of $PROJDEF ?
Can pls let me know the steps to find the default values of $PROJDEF ?
Thanks
Ram
Posted: Fri Sep 28, 2007 12:26 am
by ray.wurlod
$PROJDEF is a special token that you type in to the default value field of the job parameter.
It means "get this value from the Administrator client setting, unless manually overridden when the job run request is made".
Posted: Fri Sep 28, 2007 12:53 am
by chulett
Search your pdf documentation for $PROJDEF, you'll find it discussed in at least three of the manuals.