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)