16.20 - Two-phase commit - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

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.