StatementStatus
Purpose
Functionally replaces Success and OK parcels to provide 8-byte activity count.
Usage Notes
This parcel is generated by the Teradata server.
Parcel Data
The following table lists field information for StatementStatus.
Flavor |
Parcel Body Length |
Parcel Body Fields |
205 |
32 to maximum parcel size |
StatementStatus: 1 byte unsigned integer ResponseMode: 1 byte unsigned integer Reserved_2: 2 bytes reserved StatementNo: 4 byte unsigned integer Code: 2 byte unsigned integer ActivityType: 2 byte unsigned integer ActivityCount: 8 byte unsigned integer FieldCount: 4 byte unsigned integer Reserved_4: 4 bytes reserved The rest of the parcel, if any, consists of one or more self-defining expressions that supply any context-dependent information. Each extension is defined in the following sections: “ESS Extension Header” on page 339, “Warning Message Extension” on page 340, “Merge Activity Counts Extension” on page 340, and “Multiload Activity Counts Extension” on page 340. |
ESS Extension Header
The ESS extension header consists of the following information:
Field |
Length |
Description |
ExtInfoID |
2 byte unsigned integer |
ESS Extension Info ID 1 if warning message 10 if merge activity counts 13 if multiload activity counts |
ExtInfoLength |
4 byte unsigned integer |
length of the extension body only, not including this header |
Warning Message Extension
The Warning Message extension consists of the following information:
Field |
Length |
Description |
WarningCode |
2 byte unsigned integer |
The Database warning code, described in the Messages manual, where the warning code is the message number. |
ComponentID |
2 byte unsigned integer |
The database origin of warning code |
WarningLength |
4 byte unsigned integer |
Length of WarningMsg |
Merge Activity Counts Extension
The Merge Activity Counts extension consists of the following information:
Field |
Length |
Description |
InsertCount |
8 byte unsigned integer |
The total number of records inserted |
UpdateCount |
8 byte unsigned integer |
The total number of records updated |
DeleteCount |
8 byte unsigned integer |
The total number of records deleted |
Multiload Activity Counts Extension
The Multiload Activity Counts extension consists of the following information:
Field |
Length |
Description |
InsertCount |
8 byte unsigned integer |
The total number of records inserted |
UpdateCount |
8 byte unsigned integer |
The total number of records updated |
DeleteCount |
8 byte unsigned integer |
The total number of records deleted |
TableDBNameLength |
4 byte unsigned integer |
The length of DB table name |
TableDBName |
TableDBNameLength |
DB table name |
TableNameLength |
4 byte unsigned integer |
The length of table name |
TableName |
TableNameLength |
Table name |