17.10 - Issuing Requests: Field Mode - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)
Field Mode requests may return the following parcels:
  • EndRequest (flavor 12)
  • EndStatement (flavor 11)
  • EndWith (flavor 35)
  • Error (flavor 49)
  • Failure (flavor 9)
  • Field (flavor 18)
  • FormatEnd (flavor 23)
  • FormatStart (flavor 22)
  • NullField (flavor 19)
  • Ok (flavor 17)
  • Position (flavor 34)
  • PosEnd (flavor 47)
  • PosStart (flavor 46)
  • RecEnd (flavor 28)
  • RecStart (flavor 28)
  • Size (flavor 26)
  • SizeEnd (flavor 25)
  • SizeStart (flavor 24)
  • TitleEnd (flavor 21)
  • TitleStart (flavor 20)
  • With (flavor 33)

The following examples assume successful completion of the request.

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