All,
I need to create a second project in Datastage 8.5. I have entries in the .odbc.ini file for a set of 3 databases. In my original project, those databases are referenced as dwedw, dwhist and dwstg, and those names appear in the .odbc.ini file.
In my new project, I want to have those same three databases, dwedw, dwhist, dwstg, but they will have a different IP address/database server. uvodbc.config seems to only references the name in the .odbc.ini file. Is there any way to do this??
I did a search, but couldn't seem to find the answer.
Multiple Projects, one ODBC.ini but need different ip's
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 129
- Joined: Thu Mar 02, 2006 8:28 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
How would I do this?
1. Create separate entries in .odbc.ini for the different data sources.
2. Use the project-specific uvodbc.config files to act as filters. Within a project the only ODBC DSNs that can be used are those mentioned in the project's uvodbc.config file.
1. Create separate entries in .odbc.ini for the different data sources.
2. Use the project-specific uvodbc.config files to act as filters. Within a project the only ODBC DSNs that can be used are those mentioned in the project's uvodbc.config file.
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.