Success - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.10
Published
June 2021
Language
English (United States)
Last Update
2021-07-01
dita:mapPath
zwv1608578409227.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
Product Category
Teradata Tools and Utilities

Purpose

Returned in response to a successfully executed Teradata SQL statement in MultipartIndicator, or Indicator Response-mode when using other than Original Statement-status.

It also indicates successful completion of other types of requests (for example, a logon request).

Usage Notes

If the activity type is 33 (Echo), an echo sequence follows.

If the Warninglength is zero, there may be some slack bytes following the Warninglength. If so, they are added into the parcel length total.

This parcel is generated by the database.

Parcel Data

The following information applies to the Success parcel.

Flavor Parcel Body Length Parcel Body Fields
8 14 to 269 StatementNo:

ActivityCount:

WarningCode:

FieldCount:

ActivityType:

WarningLength:

WarningMsg:

byte unsigned integer

4 byte unsigned integer

2 byte unsigned integer

2 byte unsigned integer

2 byte unsigned integer

2 byte unsigned integer

0 to 255 bytes

Field Notes

The following notes apply to Success fields.
  • StatementNo is the number of the Teradata SQL statement for which this is the first parcel of a response.
  • ActivityCount is the total number of records selected, inserted, updated or deleted.
  • WarningCode is usually zero. If it is nonzero, it represents a comment on an operation that was carried out.
  • FieldCount is the total number of fields returned in each record.
  • ActivityType is an encoded value representing the type of Teradata SQL statement that was processed. See Activity Type for the possible activity types.
  • WarningLength is the length of the warning message. If WarningLength is zero, there is no warning message. See Teradata Vantage™ - Database Messages, B035-1096 for more information about any particular code.
  • WarningMsg is the text of the warning message.