Parcel Data|StatementStatus|CLIv2 - Parcel Data - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 20.00
Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Lake
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
ft:locale
en-US
ft:lastEdition
2024-11-15
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
lifecycle
latest
Product Category
Teradata Tools and Utilities

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

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 Database warning code, described in Teradata Vantage™ - Database Messages, B035-1096, where the warning code is the message number.
ComponentID 2-byte unsigned integer 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 Total number of records inserted
UpdateCount 8-byte unsigned integer Total number of records updated
DeleteCount 8-byte unsigned integer 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 Total number of records inserted
UpdateCount 8-byte unsigned integer Total number of records updated
DeleteCount 8-byte unsigned integer Total number of records deleted
TableDBNameLength 4-byte unsigned integer Length of DB table name
TableDBName TableDBNameLength DB table name
TableNameLength 4-byte unsigned integer Length of table name
TableName TableNameLength Table name