Page 1 of 1

Error with Enviornment variables

Posted: Wed Oct 29, 2008 8:01 am
by mdtauseefhussain
HI All

We are using 7.5 version of Datastage Server Edition.

In datastage Administrator we set the Enviornment variables as

Name Type Prompt Value
SAP_DATABASE_PAR String SAP Database AAA
SAP_USERNAME_PAR String SAP Username BBB
SAP_PASSWORD_PAR Encrypted SAP Password ****

and we used these variables in the job and it worked fine with default values and with setting $PROJDEF as well

Then we changed the name of these enviornment variables
from
SAP_DATABASE_PAR
SAP_PASSWORD_PAR
SAP_USERNAME_PAR
to
SAP_Database_Par
SAP_Password_Par
SAP_Username_Par

If i use these new variable in Job properties with default values the job is working fine.but if i set it to $PROJDEF the job is getting aborted ,when i check in the Datastage director i see blank getting passed to these Valeus instead of default values .




If you see the Director log

SAP_Database_Par=
SAP_Password_Par=LL:@1;V@N93L0O4I<;JM3KIFB<>MM0
SAP_Username_Par=

You cans see the balnk instead of default vaues
The Error " User Id is a required stage property".


Please help me to resolve this.

Posted: Wed Oct 29, 2008 8:04 am
by chulett
Please don't post the exact same thing in multiple fora, it upsets the natives. Please delete your other post.