Page 1 of 1
Writing to remote databases
Posted: Fri Jun 25, 2004 7:43 am
by pxdev
Can a Datastage PX job running on "server A" (UNIX/DB2) WRITE to database tables on the remote "server B" (UNIX/DB2).
yep
Posted: Fri Jun 25, 2004 8:58 am
by 1stpoint
you'll need to setup a connection to that database (ODBC, etc).
Posted: Fri Jun 25, 2004 12:06 pm
by pxdev
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 ?
Posted: Sat Jun 26, 2004 2:19 am
by cnguyen
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.