I have worked in a parallel job where I have included some environmental veriables as the job parameters. Then in the job I have added one ODBC Connector stage.
Now in the connector stage we have options to include the environmental veriables instead of hardcoding them. So I included the environmental veriables.
But while testing the connection it fialed because of not finding the environmental veriables.
Can anyone please tell me how to include environment variables in the ODBC Connector stage????
Using environment variables in ODBC Connector stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Include the environment variables in your job design as job parameters (click the Add Environment Variable command button).
Insert the job parameter reference where required in your Connector.
Insert the job parameter reference where required in your Connector.
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.
Ray .... we have tried the same in our job but it has not worked. The job has not run with those parameters. Our question is why it is not running? Is there any other option to do so? or this is the inability in datastage that though we include the environmental variables in the stage yet it will not run?ray.wurlod wrote:Include the environment variables in your job design as job parameters (click the Add Environment Variable command button).
Insert the job parameter reference where required in your Connector. ...
Reply.
Hi
The same thing as described by Santanu has happened in my job.
In ODBC COnnector stage in Properties in Connection option we need to give value in Data Source,Usename,password.
When we are giving hardcoded value and testing the connection it gives that Connection is fine.
But when we are inserting parameters over there it is not able to connect.It gives Connection is falied.
We give parameters by clicikng in that box where all job paramerts appear.
Is it not possible to parameterized this stage?
Please suggest.
Thanks in advence.
Shaonli
In ODBC COnnector stage in Properties in Connection option we need to give value in Data Source,Usename,password.
When we are giving hardcoded value and testing the connection it gives that Connection is fine.
But when we are inserting parameters over there it is not able to connect.It gives Connection is falied.
We give parameters by clicikng in that box where all job paramerts appear.
Is it not possible to parameterized this stage?
Please suggest.
Thanks in advence.
Shaonli