Response Sequences: Multipart Indicator Mode - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

If the Teradata SQL statement is submitted in MultipartIndicator mode (Response mode M), the response parcels for a successful statement will be as follows:

  • If the SQL statement is a non-data returning statement, then:
  • Success parcel (flavor 8)
  • If an insert, update or delete statement, the activity code will reflect the number of rows affected. All other non-data returning statements will have an activity code of 0.
  • EndStatement parcel (flavor 11)
  • EndRequest parcel (flavor 12)
  • If the SQL statement is a data returning or a SELECT statement with no WITH clause, then:
  • Success parcel (flavor 8)
  • The activity code will reflect the number of rows returned.
  • DataInfoX parcel (flavor 146)
  • Note: The following occur, once for each row returned:

  • One or more MultipartRecord parcels (flavor 144)
  • and an EndMultipartRecord parcel (flavor 145)
  • EndStatement parcel (flavor 11)
  • EndRequest parcel (flavor 12)
  • If the SQL statement is a SELECT statement having one or more WITH clauses, then:
  • Success parcel (flavor 8)
  • Activity count will reflect the number of rows returned, including summary rows.
  • DataInfoX parcel (flavor 146)
  • With parcel (flavor 33)
  • PosStart parcel (flavor 46)
  • Position parcel (flavor 34)
  • PosEnd parcel (flavor 47)
  • DataInfo parcel (flavor 71)
  • EndWith parcel (flavor 35)
  • Note: The following occur, once for each row returned:

  • One or more MultipartRecord parcels (flavor 144)
  • and an EndMultipartRecord parcel (flavor 145)
  • With parcel (flavor 33)
  • One for each summary row
  • EndWith parcel (flavor 35)
  • One for each summary row
  • EndStatement parcel (flavor 11)
  • EndRequest parcel (flavor 12)
  • If the SQL statement is a an ECHO request, then:
  • Success parcel (flavor 8)
  • One or more MultipartRecord parcels (flavor 144) and
  • an EndMultipartRecord parcel (flavor 145)
  • EndStatement parcel (flavor 11)
  • EndRequest parcel (flavor 12)