Two-phase commit is a one byte field that specifies whether the session is using the Two-phase commit protocol. When Two-phase commit 'Y' is specified, Connect-type 'C' must also be specified.
This feature requires Teradata Database for UNIX version 2 release 2 (or later), or Teradata DBS for TOS version 1 release 5 (or later).
| In this language... | The variable name for Two-phase commit is... |
|---|---|
| COBOL | DBCAREA-TWO-PHASE-COMMIT |
| PL/I | TWO_PHASE_COMMIT |
| C, C++ | two_phase_commit |
| IBM Assembler | DBO2PC |
| This routine... | Does this... |
|---|---|
| DBCHINI | writes |
| DBCHCL | reads (CON) |
| Two-phase commit is used by... | To... |
|---|---|
| applications | write |
Two-phase commit can be set to either 'Y' or 'N'.
| If the application... | Then set Two-phase commit to... |
|---|---|
| uses the Two-phase commit protocol | Y |
| does not use the Two-phase commit protocol | N |
Use mnemonics for the codes. Mnemonics are provided in the language definition file for the DBCAREA.
Two-phase commit is not valid with ANSI Transaction-semantics.