Multiple Projects, one ODBC.ini but need different ip's

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
whenry6000
Premium Member
Premium Member
Posts: 129
Joined: Thu Mar 02, 2006 8:28 am

Multiple Projects, one ODBC.ini but need different ip's

Post by whenry6000 »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply