17.10 - Parcel Data - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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

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