17.10 - 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
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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