Writing to remote databases

pxdev · Post by **pxdev** » Fri Jun 25, 2004 7:43 am

Can a Datastage PX job running on "server A" (UNIX/DB2) WRITE to database tables on the remote "server B" (UNIX/DB2).

1stpoint · Post by **1stpoint** » Fri Jun 25, 2004 8:58 am

you'll need to setup a connection to that database (ODBC, etc).

pxdev · Post by **pxdev** » Fri Jun 25, 2004 12:06 pm

So, do I need to setup two ODBC connections if I need to read from a remote server A, do some manipulation within the DataStage PX job, and write to a different remote database server B ?

cnguyen · Post by **cnguyen** » Sat Jun 26, 2004 2:19 am

you wil have to set up a Db connection to every remote database you want to read from or write to. This is asuming that database links are not used.

DSXchange

Writing to remote databases

Writing to remote databases

yep