Hi All
I have created a user defined Environment Variable called ORA_PWD and set the default value as $ENV
In the .profile I gave ORA_PWD=aaa; export ORA_PWD
if I put echo $ORA_PWD, I am able to see the value for ORA_PWD as 'aaa'
I used ORA_PWD = $ENV as job parameter in my job which contains ORACLE stage as source
I got the following error while I clicked the view button
---job parameter '$ORA_PWD' cannot take the special value '$ENV' when executing View Data. Only literal String values are allowed
when I ran the job I got the following error
---Missing Parameters $ORA_PWD [$ENV].
1. My question is do I have to restart the server after declaring ORA_PWD=$ENV?
2. Am I missing something while trying to get a value from the environment. If yes what is it?
I just went to almost all the post here, I guess I am missing something
Setting user defined Environment Variable to $ENV
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 54
- Joined: Thu Oct 18, 2007 4:20 am
- Location: Chennai
Setting user defined Environment Variable to $ENV
Regards
LakshmiNarayanan
LakshmiNarayanan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
In 7.5x2 View Data does not accept environment variable parameters with $PROJDEF, $ENV or $UNSET as default values at all.
You should not need to start the server. However, you probably do need to create an environment variable called ORA_PWD in the Administrator client. Set that one's default value as $ENV also.
You should not need to start the server. However, you probably do need to create an environment variable called ORA_PWD in the Administrator client. Set that one's default value as $ENV also.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 54
- Joined: Thu Oct 18, 2007 4:20 am
- Location: Chennai
Thanks Ray
This is what I did to get the value of ORA_PWD from the Environment
I assigned a value for variable called PWD=aaa and then used the below command in the .profile
PWD=aaa;
export $PWD (dont know whether this is necessary or not)
dsadmin -envset ORA_PWD -value $PWD ProjectName
in the Administrator I kept ORA_PWD as string and DataStage took care of the rest
and each and every job I used $PRODEF for ORA_PWD
if I change PWD value in the .profile then ORA_PWD will change automatically in DataStage
This is what I did to get the value of ORA_PWD from the Environment
I assigned a value for variable called PWD=aaa and then used the below command in the .profile
PWD=aaa;
export $PWD (dont know whether this is necessary or not)
dsadmin -envset ORA_PWD -value $PWD ProjectName
in the Administrator I kept ORA_PWD as string and DataStage took care of the rest
and each and every job I used $PRODEF for ORA_PWD
if I change PWD value in the .profile then ORA_PWD will change automatically in DataStage
Regards
LakshmiNarayanan
LakshmiNarayanan
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 54
- Joined: Thu Oct 18, 2007 4:20 am
- Location: Chennai