DSXchange

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 ??

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...

Look in to Server Job Developers Guide for DB2 and ODBC.