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
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
ggf1488824663364.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2418
lifecycle
previous
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 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 The Database warning code, described in the Messages (B035-1096) 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