DNS Names

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
mkeevil
Participant
Posts: 59
Joined: Mon Jul 14, 2003 12:59 pm
Location: USA

DNS Names

Post by mkeevil »

I am tring to import a stored procedure definition, but the DNS name is not showing in the drop down box. Anyone know where the config file is located to add the new DNS names?
rgandra
Premium Member
Premium Member
Posts: 49
Joined: Mon Aug 02, 2004 9:31 am
Contact:

Post by rgandra »

check for the uvodbc.config file in your project folder. Syntax to add DSN is there in the file.

-Sandeep
kcbland
Participant
Posts: 5208
Joined: Wed Jan 15, 2003 8:56 am
Location: Lutz, FL
Contact:

Post by kcbland »

For ODBC stages it's uvodbc.config in the project directory, as long as you've already defined the connection in odbc.ini in the engine directory.
Kenneth Bland

Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

You may find that it's a hidden file (that is, the first character of its name is a ".", that is ".odbc.ini"). Usually the pathname of this file is also available via the ODBCINI environment variable.
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