How to connect DS cleint with DB2 on the server

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
Amar_nath
Participant
Posts: 56
Joined: Tue Apr 18, 2006 5:03 am

How to connect DS cleint with DB2 on the server

Post by Amar_nath »

hello,

I am new to DS,

I am having a unix server for DS on which DB2 installed

now I want to connect to Sample db in DB2 in server job

I kno how to connect throgh Command Line Tools in DB2 but from DS how to use the Tables present in database on DB2 server

suggetions ??
koolnitz
Participant
Posts: 138
Joined: Wed Sep 07, 2005 5:39 am

Post by koolnitz »

Hi Amar,

First, you can try with SEARCH mechanism in this site. I kill 90% of the my queries looking at already posted topics.

Second, you can use DB2 stage (preferably, and ODBC optionally) to point to a DB2 table. You need to have all the info required to connect to the database with proper authorization to access the table, e.g. Database server details, database name, schema name, username, password and blah blah...
Nitin Jain | India

If everything seems to be going well, you have obviously overlooked something.
kumar_s
Charter Member
Charter Member
Posts: 5245
Joined: Thu Jun 16, 2005 11:00 pm

Post by kumar_s »

Look in to Server Job Developers Guide for DB2 and ODBC.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
Post Reply