応答シーケンス: 標識モード - Call-Level Interface Version 2

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

• データを返さない文:

  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)

• データを返す文またはWITH句なしのSELECT文:

  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)

• 1つ以上のWITH句があるSELECT文:

  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)

• ECHOリクエスト:

  Success parcel (flavor 8)
  Record parcel (flavor 10) in record-mode format
  EndStatement parcel (flavor 11)
  EndRequest parcel (flavor 12)