A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.
Moderators: chulett , rschirm , roy
m_mani87
Participant
Posts: 45 Joined: Thu May 24, 2012 11:13 pm
Location: Coimbatore
Post
by m_mani87 » Mon Sep 02, 2013 5:10 am
Hi all,
I know that uvodbc.config is used to connect to remote database.
But the file is present in two places
1) $DSHOME
2) In each Project Path
But the one that is present in thr Project Path has only localuv like below
[ODBC DATA SOURCES]
<localuv>
DBMSTYPE = UNIVERSE
network = TCP/IP
service = uvserver
host = 127.0.0.1
If i want to connect to a new database is it enough to add in the file in DSHOME path?
If so what is the significance of the file in project path?
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Mon Sep 02, 2013 7:15 am
You need to update the information in $DSHOME as well as in every project that you want to use the ODBC connection.
-craig
"You can never have too many knives" -- Logan Nine Fingers
asorrell
Posts: 1707 Joined: Fri Apr 04, 2003 2:00 pm
Location: Colleyville, Texas
Post
by asorrell » Tue Sep 03, 2013 8:07 am
And as to the other point (significance), the file can be used to limit access to ODBC connections on a project level (by excluding them from the specific project config file).
m_mani87
Participant
Posts: 45 Joined: Thu May 24, 2012 11:13 pm
Location: Coimbatore
Post
by m_mani87 » Wed Sep 04, 2013 8:57 am
Thanks all
Some what it answers my questions. So i am marking it as resolved
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Sep 04, 2013 10:21 am
"Some what"? Give us a shot at clarifying whatever remains unanswered or unclear...
-craig
"You can never have too many knives" -- Logan Nine Fingers