応答シーケンス: フィールド モード - Call-Level Interface Version 2

Teradata® Call-Level Interfaceバージョン2リファレンス - ワークステーション接続システム

Product
Call-Level Interface Version 2
Release Number
17.10
Published
2021年6月
Language
日本語
Last Update
2021-09-23
dita:mapPath
ja-JP/ttt1608578409164.ditamap
dita:ditavalPath
ja-JP/ttt1608578409164.ditaval
dita:id
B035-2418
Product Category
Teradata Tools and Utilities

Teradata SQL文をフィールド モード(Response Mode=F)で実行依頼した場合には、成功した文に対する応答シーケンスは、次に示すSQL文の種類に応じて以下のようになります。

  • データを返さない文:
    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)
  • データを返す文またはWITH句なしのSELECT文:
    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)
  • 1つ以上のWITH句があるSELECT文:
    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)
  • ECHOリクエスト:
    Ok parcel (flavor 17)
    RecStart parcel (flavor 27)
    Field parcel (flavor 18)
    RecEnd parcel (flavor 28)
    EndStatement parcel (flavor 11)
    EndRequest parcel (flavor 12)