Record Mode |CLI - Response Sequences: Record 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 Record Mode (Response Mode = R), the response parcels 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
    Record Parcel (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)
       the activity code will reflect the number
       of rows returned, including the summary
       rows
    Record Parcel (flavor 10)
       one record parcel for each row returned,
       including the summary rows
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor 12)
    
    With parcel (flavor 33)
       one for each summary row immediately
       preceding the Record parcel containing the
       summary row.
    EndWith parcel (flavor 35)
       one for each summary row immediately
       following the Record parcel containing the
       summary row.
  • An ECHO request
    Success parcel (flavor 8)
    Record parcel (flavor 10)
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor 12)