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

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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
Language
English (United States)
Last Update
2024-05-14
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
Product Category
Teradata Tools and Utilities
If the Teradata SQL statement is submitted in Multipart Indicator 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)
      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)
      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)