Page 1 of 1

Error with Enviornment variables

Posted: Wed Oct 29, 2008 4:06 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 .

Please help me to resolve this.

Thanks in Advace

Mohammed Tausif

Posted: Wed Oct 29, 2008 5:31 am
by ArndW
Did you change the values in the Administrator tool or did you edit the files from UNIX? The first line in the log of a job run will show the ENV values - which parameters are declared there, the old names or the new ones?

Posted: Wed Oct 29, 2008 5:53 am
by mdtauseefhussain
I changed the values in Datastage Administrator

Posted: Wed Oct 29, 2008 5:56 am
by mdtauseefhussain
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".