Response Sequences: 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
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

If the Teradata SQL statement was submitted in Indicator Mode (Response Mode = I), the response sequence for a successful statement will be as follows if the SQL statement is:

  • A non-data returning statement
    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)
  • A data returning statement or SELECT statement with no WITH clause
    Success parcel (flavor 8)
       the activity code will reflect the number
       of rows returned
    DataInfo parcel (flavor 71)
    Record parcels (flavor 10)
       one record parcel for each row returned.
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor 12)
  • A Select statement having one or more WITH clauses
    Success parcel (flavor 8)
       activity count will reflect the number of
       rows returned, including summary rows.
    DataInfo parcel (flavor 71)
    With parcel (flavor 33)
    PosStart parcel (flavor 46)
    Position parcel (flavor 34)
    PosEnd parcel (flavor 47)
    DataInfo parcel (flavor 71)
    EndWith parcel (flavor 35)
    Record parcel (flavor 10)
       one record parcel for each row returned
    With parcel (flavor 33)
       one for each summary row
    Record parcel (flavor 10)
    EndWith parcel (flavor 35)
       one for each summary row
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor 12)
  • An ECHO request
    Success parcel (flavor 8)
    Record parcel (flavor 10) in record-mode format
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor 12)