Paramter sets

samsuf2002 · Post by **samsuf2002** » Thu Mar 12, 2009 1:04 pm

Is it possible to use $PROJDEF in parameter set value file, I mean in the value file if I provide $PROJDEF as default value for any environment variable its not working unless I provide the actual value for it.

example --

For environment variable $DATABASE with default value SEQDEV if I specify it as $PROJDEF in one of the value file then its not fetching the value SEQDEV but if I directly provide the default in value file as SEQDEV then its fine.

Any suggestions would be helpful.

lstsaur · Post by **lstsaur** » Thu Mar 12, 2009 3:01 pm

You should put the $PROJDEF in the Default Value of the Parmaters tab instead of in the Value File name.

samsuf2002 · Post by **samsuf2002** » Thu Mar 12, 2009 3:07 pm

Then what should be default in the value file ?

What I observed is what ever you default in value file is what its using ..... No matter what you have in Parameter tab default.

ray.wurlod · Post by **ray.wurlod** » Thu Mar 12, 2009 3:15 pm

$PROJDEF works properly (does not need to be overridden) in version 8.1.

I have not yet tried to specify $PROJDEF as a default value for an environment variable parameter in a values file, but see no reason that it would not work.

samsuf2002 · Post by **samsuf2002** » Thu Mar 12, 2009 3:23 pm

Even I believe Ray that there should be no reason it shouldn't work, but in my case I tried different option still its not working.

Since this is a new addition to Data stage, I think not many people have tried using this.