16.20 - Issuing Requests—Field Mode - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

Field Mode requests may return the following parcels:

Name Flavor
Failure 9
Error 49
StatementError 192
OK 17
ResultSummary 171
Field 18
With 33
EndWith 35
FormatStart 22
FormatEnd 23
NullField 19
PosStart 46
Position 34
PosEnd 47
RecStart 28
RecEnd 28
SizeStart 24
Size 26
SizeEnd 25
TitleStart 20
TitleEnd 21
EndStatement 11
EndRequest 12

The following examples assume successful completion of the request when using Original Statement-status. If using Enhanced Statement-status, OK parcels may be replaced by StatementStatus parcels. See Parcels for Basic Applications or Parcels for Advanced Applications for detailed descriptions of parcels.

UPDATE TABLE1 SET FIELD1 = 999999;
Parcel Flavor Body
OK 17 (1, 0, 23, 3, 0, 0)
EndStatement 11 (1)
EndRequest 12  
SELECT FIELD1 FROM TABLE1;     
Parcel Flavor Body
OK 17 (1, 1, 23, 1, 0, 0)
TitleStart 20  
Field 18 (title)
TitleEnd 21  
FormatStart 22  
Field 18 (format)
FormatEnd 23  
SizeStart 24  
Size 26 (size)
SizeEnd 25  
RecStart (1) 27  
Field 18 (data)
RecEnd (1) 28  
  .

  .

  .

 .

 .

 .

 
RecStart (23) 27  
Field 18 (data)
RecEnd (23) 28  
EndStatement 11 (1)
EndRequest 12  
SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1)
Parcel Flavor Body
OK 17 (1, 1, 24, 1, 0, 0)
TitleStart 20  
Field 18 (title)
TitleEnd 21  
FormatStart 22  
Field 18 (format)
FormatEnd 23  
SizeStart 24  
Size 26 (size)
SizeEnd 25  
With 33 (1)
PosStart 46  
Position 34 (1)
PosEnd 47  
TitleStart 20  
Field 18 (title)
TitleEnd 21  
FormatStart 22  
Field 18 (format)
FormatEnd 23  
SizeStart 24  
Size 26 (size)
SizeEnd 25  
EndWith 35 (1)
RecStart (1) 27  
Field 18 (data)
RecEnd (1) 28  
  .

  .

  .

 .

 .

 .

 
RecStart (23) 27  
Field 18 (data)
RecEnd (23) 28  
With 33 (1)
Field 18 (data)
EndWith 35 (1)
EndStatement 11 (1)
EndRequest 12  
SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2;
Parcel Flavor Body
OK 17 (1, 1, 23, 1, 0, 0)
TitleStart 20  
Field 18 (title)
TitleEnd 21  
FormatStart 22  
Field 18 (format)
FormatEnd 23  
SizeStart 24  
Size 26 (size)
SizeEnd 25  
RecStart (1) 27  
Field 18 (data)
RecEnd (1) 28  
  .

  .

 .

 .

 
RecStart (23) 27  
Field 18 (data)
RecEnd 28  
EndStatement 11 (1)
OK 17 (2, 1, 10, 1, 0, 0)
TitleStart 20  
Field 18 (title)
TitleEnd 21  
FormatStart 22  
Field 18 (format)
FormatEnd 23  
SizeStart 24  
Size 26 (size)
SizeEnd 25  
RecStart (1) 27  
Field 18 (data)
RecEnd (1) 28  
  .

  .

  .

 .

 .

 .

 
RecStart (10) 27  
Field 18 (data)
RecEnd (10) 28  
EndStatement 11 (2)
EndRequest 12  
ECHO ̀SELECT FIELD1 FROM TABLE1́;
Parcel Flavor Body
OK 17 (1, 1, 0, 33, 0, 0)
RecStart 27  
Field 18 (data)
RecEnd 28  
EndStatement 11 (1)
EndRequest 12