17.10 - Response Sequences: Field 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
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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

  • A non-data returning statement
    Ok parcel (flavor 17)
       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
    Ok parcel (flavor 17)
       activity count will reflect the number of
       rows returned
    TitleStart parcel (flavor 20)
    Field parcel (flavor 18)
       one field parcel for each column returned
    TitleEnd parcel (flavor 21)
    FormatStart parcel (flavor 22)
    Field parcels (flavor 18)
       one field parcel for each column returned
    FormatEnd parcel (flavor 23)
    SizeStart parcel (flavor 24)
    Size parcel (flavor 26)
       one size parcel for each column returned
    SizeEnd parcel (flavor 25)
    
    The following parcel sequence repeats activity count times
       RecStart parcel (flavor 27)
       Field parcels (flavor 18)
          one field parcel for each column
          returned
       RecEnd parcel (flavor 28)
    
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor12)
  • A SELECT statement having one or more WITH clauses
    Ok parcel (flavor 17)
       activity count will reflect the number of
       rows returned
    TitleStart parcel (flavor 20)
    Field parcel (flavor 18)
       one field parcel for each column returned
    TitleEnd parcel (flavor 21)
    FormatStart parcel (flavor 22)
    Field parcels (flavor 18)
       one field parcel for each column returned
    FormatEnd parcel (flavor 23)
    SizeStart parcel (flavor 24)
    Size parcels (flavor 26)
       one size parcel for each column returned
    SizeEnd parcel (flavor 25)
    
    The following parcel sequence repeats for each WITH clause
       With parcel (flavor 33)
          PosStart parcel (flavor 46)
          Position parcel (flavor 34)
             one position parcel for each column
             in WITH
          PosEnd parcel (flavor 47)
          TitleStart parcel (flavor 20)
          Field parcels (flavor 18)
             one field parcel for each column in
             WITH
          TitleEnd parcel (flavor 21)
          FormatStart parcel (flavor 22)
          Field parcels (flavor 18)
             one field parcel for each column
             returned
          FormatEnd parcel (flavor 23)
          SizeStart parcel (flavor 24)
          Size parcels (flavor 26)
             one size parcel for each column
             returned
          SizeEnd parcel (flavor 25)
       EndWith parcel (flavor 35)
    
    The following parcel sequence repeats activity count times
       RecStart parcel (flavor 27)
       Field parcels (flavor 18)
          one field parcel for each column
          returned
       RecEnd parcel (flavor 28)
    
    
       With parcel (flavor 33)
          RecStart parcel (flavor 27)
          Field parcels (flavor 18)
             one field parcel for each column in
             WITH
          RecEmd parcel (flavor 35)
       EndWith parcel (flavor 35)
    
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor 12)
  • An ECHO request
    Ok parcel (flavor 17)
    RecStart parcel (flavor 27)
    Field parcel (flavor 18)
    RecEnd parcel (flavor 28)
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor 12)