Environment Variables are not refreshing in JOB

ramaiahn · Post by **ramaiahn** » Thu Sep 27, 2007 8:43 pm

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

ray.wurlod · Post by **ray.wurlod** » Thu Sep 27, 2007 9:02 pm

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

chulett · Post by **chulett** » Thu Sep 27, 2007 9:39 pm

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.

ramaiahn · Post by **ramaiahn** » Thu Sep 27, 2007 10:24 pm

Using Data Stage Standard Version 7.5.2

Thanks
Ramaiah

chulett · Post by **chulett** » Thu Sep 27, 2007 10:49 pm

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?

ramaiahn · Post by **ramaiahn** » Thu Sep 27, 2007 11:13 pm

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

chulett · Post by **chulett** » Thu Sep 27, 2007 11:49 pm

Please answer the question that was asked. What is the default value of this parameter in the job... $PROJDEF?

ramaiahn · Post by **ramaiahn** » Fri Sep 28, 2007 12:11 am

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

ray.wurlod · Post by **ray.wurlod** » Fri Sep 28, 2007 12:26 am

$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".

chulett · Post by **chulett** » Fri Sep 28, 2007 12:53 am

Search your pdf documentation for $PROJDEF, you'll find it discussed in at least three of the manuals.