Environment variables
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Environment variables
Hi Forum,
In my server exists 2 projects, Desarrollo y Certificacion, and each project access to different oracle database. I set in my jobs the environment variables for each project with diferents values, but, when i open the job in Desarrollo shown the rigth values configured for this project, and when i open the job in the Certificacion show the same values!!!
The variables for each projects are: (was settings with Administrator-->Environment)
Desarrollo
************
USER = U100
PASS = xxxx
Certificacion
*************
USER = U200
PASS = yyyy
why show the values of Desarrollo project when i open the certificacion job???
Thanks !!!
In my server exists 2 projects, Desarrollo y Certificacion, and each project access to different oracle database. I set in my jobs the environment variables for each project with diferents values, but, when i open the job in Desarrollo shown the rigth values configured for this project, and when i open the job in the Certificacion show the same values!!!
The variables for each projects are: (was settings with Administrator-->Environment)
Desarrollo
************
USER = U100
PASS = xxxx
Certificacion
*************
USER = U200
PASS = yyyy
why show the values of Desarrollo project when i open the certificacion job???
Thanks !!!
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
Re: Environment variables
You sure you did not hack into the same DSParams file? I guess so, isnce you have mentioned that you used the Admin client. This is weird.
Try leaving some variable values in the Certificacion project as empty, and check what happens?
What happens when you open the Desarrollo project? Is it that the values for Desarrollo project being shown in both projects, or are they interchanged?jseclen wrote: why show the values of Desarrollo project when i open the certificacion job???
Try leaving some variable values in the Certificacion project as empty, and check what happens?
gateleys
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Re: Environment variables
Hi gateleys
I change the values for empty in Certificacion project user variables, and open my job, view the odbc stage and show me the Desarrollo values again.
Is necessary restart the services to take the last changes????
Thanks.
I change the values for empty in Certificacion project user variables, and open my job, view the odbc stage and show me the Desarrollo values again.
Is necessary restart the services to take the last changes????
Thanks.
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
Re: Environment variables
For some reason, it seems that your env variables are being written to the same DSParams file? Can you check the DSParams file for hte Certificacion project and scroll down to the check for the values?jseclen wrote:Hi gateleys
I change the values for empty in Certificacion project user variables, and open my job, view the odbc stage and show me the Desarrollo values again.
Is necessary restart the services to take the last changes????
Thanks.
gateleys
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
I don't think that's right, because changing to "" in Administrator had no effect.
Are you clicking Cancel (rather than OK) to close the Administrator windows?
It is not necessary to re-start services, but it might be interesting to open a new Administrator client after making these changes.
Are you clicking Cancel (rather than OK) to close the Administrator windows?
It is not necessary to re-start services, but it might be interesting to open a new Administrator client after making these changes.
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.
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Hi Ray, thanks for your help, but dont work, i changed the variables in Desarrollo and close the window. open another administrator and set new values for certificacion, and press Ok button ...
In the manager open the job from the Desarrollo and Certificacion projects, but is the same result ... show me the values of desarrollo
In the manager open the job from the Desarrollo and Certificacion projects, but is the same result ... show me the values of desarrollo
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Hi gateleys,
Both files contains the values defined in this administrator window for each one, in desarrollo and certificacion are differents.
DSParams from Desarrollo
[EnvVarValues]
"XCP_DB"\1\"XCPDWX_odbc"
"XCP_USER"\1\"IU231275"
"XCP_PASS"\1\"LD:@09VDM4K"
DSParams from Certificacion
[EnvVarValues]
"XCP_BD"\1\" ertertert"
"XCP_USER"\1\"ertertertert"
"XCP_PASS"\1\"LDH@9HVH=9;L0O4I4:"
Now, what is the next step????
p.d. when i was changing the text value and double-click appear a new window that permit to set this text as $ENV or $UNSET, what is the funcionality for this?
Both files contains the values defined in this administrator window for each one, in desarrollo and certificacion are differents.
DSParams from Desarrollo
[EnvVarValues]
"XCP_DB"\1\"XCPDWX_odbc"
"XCP_USER"\1\"IU231275"
"XCP_PASS"\1\"LD:@09VDM4K"
DSParams from Certificacion
[EnvVarValues]
"XCP_BD"\1\" ertertert"
"XCP_USER"\1\"ertertertert"
"XCP_PASS"\1\"LDH@9HVH=9;L0O4I4:"
Now, what is the next step????
p.d. when i was changing the text value and double-click appear a new window that permit to set this text as $ENV or $UNSET, what is the funcionality for this?
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru
OK, in the job parameter window, set each of those variables to $PROJDEF. Now, see if it points to the right parameter value.jseclen wrote: p.d. when i was changing the text value and double-click appear a new window that permit to set this text as $ENV or $UNSET, what is the funcionality for this?
$PROJDEF would assign the value that you defined in the User Variables grid in Administrator.
gateleys
-
- Participant
- Posts: 133
- Joined: Wed Mar 05, 2003 4:19 pm
- Location: Lima - Peru. Sudamerica
- Contact:
Ok now is working ... thanks.
I have a new question about that.
How create a job will use the values of Environment Variables in the job parameters????
For example:
Job1 in Desarrollo use the follow parameters and values
pXCP_DB = BASE1 (define in XCP_DB in Administrator)
pXCP_USER = u020 (define in XCP_USER in Administrator)
pXCP_PASS = xxx (define in XCP_PASS in Administrator)
my wish is when pass to Certificacion this job must be run using the values defined in the Environment Variables for this project, so, the default value may be take the value of environment at run??
Job1 must be use this values:
XCP_DB = BASE10
XCP_USER = u2000
XCP_PASS = yyy
is there a way to make this????
I have a new question about that.
How create a job will use the values of Environment Variables in the job parameters????
For example:
Job1 in Desarrollo use the follow parameters and values
pXCP_DB = BASE1 (define in XCP_DB in Administrator)
pXCP_USER = u020 (define in XCP_USER in Administrator)
pXCP_PASS = xxx (define in XCP_PASS in Administrator)
my wish is when pass to Certificacion this job must be run using the values defined in the Environment Variables for this project, so, the default value may be take the value of environment at run??
Job1 must be use this values:
XCP_DB = BASE10
XCP_USER = u2000
XCP_PASS = yyy
is there a way to make this????
Saludos,
Miguel Seclén
Lima - Peru
Miguel Seclén
Lima - Peru