Error with Enviornment variables
Posted: Wed Oct 29, 2008 8:01 am
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.
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.