This is a discussion on two-phase-commit with nicknames on 8.2.2 linux SQL/PL procedure? within the DB2 forums, part of the Database Server Software category; --> On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure use two-phase-commit with nicknames and if DB2 provides ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| On Linux or Solaris with UDB 8.2.2, can an SQL/PL stored-procedure use two-phase-commit with nicknames and if DB2 provides the Transaction-manager? i.e. in the same transaction, can an SQL/PL procedure update a local table and also update a nicknamed-table (in another database on the same hostname), before committing ? Is this possible, or must I have a CLI procedure and not use nicknames? |