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