need to create dsn in unix

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
cosec
Premium Member
Premium Member
Posts: 230
Joined: Tue May 08, 2007 8:10 pm

need to create dsn in unix

Post by cosec »

I need to create a DSN in unix so that I could import table definitions from a remote source. If anyone knows please suggest how I could do it .

Thanks
Ankit
Participant
Posts: 21
Joined: Mon Nov 13, 2006 12:06 am
Location: India

Re: need to create dsn in unix

Post by Ankit »

cosec wrote:I need to create a DSN in unix so that I could import table definitions from a remote source. If anyone knows please suggest how I could do it .

Thanks
First you need to create the ODBC connection(if it doesnt' already exists) in .odbc.ini file with all the connection details, then you need to
the DSN name in uvodbc.config file at the project level.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

What 'remote source'? If there is a native stage, use it, otherwise you'll need to create something and use ODBC.
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply