DSXchange

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.

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

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.

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

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.