connecting to DB2 database from datastage unix server

venkatvelpula · Post by **venkatvelpula** » Wed Sep 30, 2009 3:56 pm

I am trying to do DB2 spool script...working for oracle

Trying to connect to DB2 database from datastage server using odbc drivers or db2 connect.

Either one is not working...Any thoughts on this....

chulett · Post by **chulett** » Wed Sep 30, 2009 4:05 pm

My thoughts?

Hmmm... I wonder what "not working" means?
Hmmm... I wonder what trying to connect "from datastage unix server" means?

ray.wurlod · Post by **ray.wurlod** » Wed Sep 30, 2009 8:01 pm

"Not working" means unemployed.

Can't help with the second one.

venkatvelpula · Post by **venkatvelpula** » Thu Oct 01, 2009 9:37 am

ray.wurlod wrote:"Not working" means unemployed.

Can't help with the second one.

The requirement is to connect to DB2 database using the odbc drives comes with the datastage product.

Datasatge stages are working but need to do it through the scripting from the server.

Any thoughts would be highly appreciated !

chulett · Post by **chulett** » Thu Oct 01, 2009 9:48 am

The drivers that ship with the product are not licensed for use outside of the product stages. Why not use whatever command line DB2 provides, like sqlplus for Oracle?