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.
- 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 |