17.10 - Response Parcels: Overview - 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)

These parcels are generated by the database. The application program can see all of them directly.

The following table lists the response parcels in numerical order.

Parcel Flavor Parcel Name Parcel Use Parcel Length Fields in Parcel Body
8 Success Indicates that the specified Teradata SQL statement completed successfully 18-273
  • StatementNo
  • ActivityCount
  • WarningCode
  • FieldCount
  • ActivityType
  • WarningLength
  • WarningMsg
9 Failure Indicates that the specified statement has a failed and the entire transaction was rolled back 13-267
  • StatementNo
  • Info
  • Code
  • Length
  • Msg
  • InsCount
  • InsTriad
10 Record Returns one row of selected results 5-32004/65104 Data
11 EndStatement Delimits the end of the results from the specified Teradata SQL statement 6 StatementNo
12 EndRequest Delimits the end of a Teradata SQL response to a DBC/SQL request 4 None
17 Ok Indicates that the specified Teradata SQL statement completed successfully 18-273
  • StatementNo
  • FieldCount
  • ActivityCount
  • ActivityType
  • WarningCode
  • WarningLength
  • WarningMsg
18 Field Contains returned information (data value, title, format, or echo) 4-32004/65104 Data
19 NullField Returns a null data value for a field 4 None
20 TitleStart Delimits the start of a set of format-containing Field parcels 4 None
21 TitleEnd Delimits the end of a set of format-containing Field parcels 4 None
22 FormatStart Delimits the start of a set of format-containing Field parcels 4 None
23 FormatEnd Delimits the end of a set of format-containing Field parcels 4 None
24 SizeStart Delimits the start of a set of Size parcels 4 None
25 SizeEnd Delimits the end of a set of Size parcels 4 None
26 Size Specified the width of a column of selected results 4 MaxFldSize
27 RecStart Delimits the start of a set of data-value containing Field and Null-Field parcels or a set of echoed string- containing Field parcels 4 None
28 RecEnd Delimits the end of a set of data-value containing Field and Null-Field parcels or a set of echoed string- containing Field parcels 4 None
32 NOP Sends test messages to make sure the connection is still alive. 4 None
33 With Delimits the start of a set of parcels for the specified WITH clause 6 WithId
34 Position Specifies the column number being summarized 6 ColumnNo
35 EndWith Delimits the end of a set of parcels for the specified WITH clause 6 WithId
46 PosStart Delimits the start of a set of Position parcels 3 None
47 PosEnd Delimits the end of a set Position parcels 4 None
49 Error Indicates that the specified statement has an error not serious enough to cause rollback 13-267
  • StatementNo
  • Info
  • Code
  • Length
  • Msg
  • InsCount
  • InsTriad
71 DataInfo Returns a description of the following Indicator Mode Record parcels 6-32004/65104 FieldCount Pairs:

 Length

 Type

86 PrepInfo Returns column information to the database when a Teradata SQL statement has been prepared using the Request Processing Option. 16 to 32004/65104 None
101 AssignRsp Assigns a session COP by returning the information needed for the workstation to connect to the database. 76
  • PublicKey
  • SesCOPAddr
  • PublicKeyN
  • RelArray
  • VerArray
  • HostId
121 CursorDBC Returns cursor information. 14 Processor

Row

122 Flagger Returns language nonconformances. 10 to 32004/65104 Flags
164 ErrorInformation After an Error parcel (flavor 49), provides additional information about the error. 1 to maximum parcel size
  • InformationID
  • Information
  • Length
  • Information
169 StatementInformation Returns a description of the data, when Return-statement_info ‘Y’ was returned. 6 to maximum parcel size
  • PBTILOUT
  • PBTIID
  • PBTILEN
170 StatementInformationEnd Delimits related StatementInformation parcels. 0 none
172 ResultSet Introduce parcels returned from a CALLed stored procedure. 12
  • PBRTRNUM
  • PBRTDB
  • PBRTPN
192 StatementError Provides independent statement errors for multi-statement requests. 12 to 271
  • StatementNo
  • Info
  • Code
  • Length
  • Msg
205 StatementStatus Functionally replaces Success and OK parcels to provide 8-byte activity count. 32 to maximum parcel size
  • StatementStatus
  • ResponseMode
  • StatementNo
  • Code
  • ActivityType
  • ActivityCount
  • FieldCount