VoteTerm - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
ttt1608578409164.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Purpose

Requests a vote-and-terminate action in a 2PC session.

The VoteTerm parcel either can be sent alone or in a message (at the end of a sequence of request and data parcels that define a Teradata SQL statement).

Usage Notes

If the VoteTerm parcel is used with updates that change existing data, it always results in a commit.

If an immediate commit is not desired, use the VoteRequest parcel instead of the VoteTerm parcel.

If the VoteTerm parcel is sent in the same message as a Teradata SQL statement, the vote and terminate request follows the rules for a multi-statement request (all statements succeed, or all fail).

If your program is using the Initiate with Protocol-Function with the vote/terminate function, the VoteTerm parcel is included after the request and data parcels.

The response is one of the following:
  • A Success parcel indicating that the database committed the transaction
  • A Failure parcel indicating that the database rolled back the transaction or that the session is not in 2PC mode.

    The error code in the Failure parcel indicates why the database could not commit the transaction.

Parcel Data

The following information applies to the VoteTerm parcel.

Flavor Parcel Body Length Parcel Body Fields
116 0 none