VoteTerm - Call-Level Interface Version 2

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
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