Error with Enviornment variables

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
mdtauseefhussain
Participant
Posts: 38
Joined: Mon Feb 27, 2006 10:34 pm
Location: Chennai
Contact:

Error with Enviornment variables

Post 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.
Mohammed Tausif Hussain Sheikh
Cognizant technologies,Perungudi
Chennai
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Please don't post the exact same thing in multiple fora, it upsets the natives. Please delete your other post.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply