VoteTerm - Teradata Director Program

Teradata® Director Program Reference - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Teradata Director Program
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-17
dita:mapPath
cki1641301536147.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
frc1470439950465
Product Category
Teradata Tools and Utilities

Purpose

Requests a vote-and-terminate action in a Two-phase commit 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, then 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, then 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 has committed the transaction
  • A Failure parcel indicating that the database has rolled back the transaction or that the session is not in Two-phase commit mode.

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

Parcel Data

Field information applies for the VoteTerm parcel as follows:

Flavor Parcel BodyLength Parcel Body Fields
116 0 none