Response Sequences: Field Mode - Call-Level Interface Version 2

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)