DB2 Connect - ISeries Access
Posted: Tue Oct 12, 2004 9:13 am
Hi,
We use DB2 for AS400 V5R2 (soon V5R3) as source and target database for our datawarehouse. We currently use DB2 Connect (Version 7.2) to connect the DB2 UDB stage in Datastage to our DB2 Database. This is the only environment where we use DB2 Connect, because elsewhere (eg Business Object/WebIntelligence) we connect to DB2 using ISeries Acces (formerly Client Access)
We have tested Client Access with Datastage DB2 UDB stage in the past, and we managed to make it work in read-only mode.
There are other topics on AS400 connectivity on this site, but I haven't read nowhere if you can use Client Access/ISeries Access to connect to DB2 on AS400 with UPDATES (and deletes, ... in fact all SQL statements).
If someone uses ISeries Access both for read and update, can you tell with which version of the driver you work and which configuration settings you use.
Thanks,
Wim
We use DB2 for AS400 V5R2 (soon V5R3) as source and target database for our datawarehouse. We currently use DB2 Connect (Version 7.2) to connect the DB2 UDB stage in Datastage to our DB2 Database. This is the only environment where we use DB2 Connect, because elsewhere (eg Business Object/WebIntelligence) we connect to DB2 using ISeries Acces (formerly Client Access)
We have tested Client Access with Datastage DB2 UDB stage in the past, and we managed to make it work in read-only mode.
There are other topics on AS400 connectivity on this site, but I haven't read nowhere if you can use Client Access/ISeries Access to connect to DB2 on AS400 with UPDATES (and deletes, ... in fact all SQL statements).
If someone uses ISeries Access both for read and update, can you tell with which version of the driver you work and which configuration settings you use.
Thanks,
Wim