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
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
uny1527114222311.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities
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