Issuing Requests: Indicator 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
Indicator Mode requests may return the following parcels:
  • DataInfo (flavor 71)
  • EndRequest (flavor 12)
  • EndStatement (flavor 11)
  • EndWith (flavor 35)
  • Error (flavor 49)
  • Failure (flavor 9)
  • PosEnd (flavor 47)
  • Position (flavor 34)
  • PosStart (flavor 46)
  • Record (flavor 10)
  • Success (flavor 8)
  • With (flavor 33)

The following examples assume successful completion of the request.

Update Table1 Set Field1 = 999999; 
Parcel Flavor Body
Success 8 (1, 23, 0, 0, 3, 0)
EndStatement 11 (1)
EndRequest 12  
Select Field1 From Table1;  
Parcel Flavor Body
Success 8 (1, 23, 0, 1, 1, 0)
DataInfo 71 (1, 496, 4)
  • Record (1)
  • .
  • .
  • .
  • Record (23)
  • 10
  • .
  • .
  • .
  • 10
  • (ind, data)
  • .
  • .
  • .
  • (ind, data)
EndStatement 11 (1)
EndRequest 12  
Select Field1 From Table1 With Sum (Field1); 
Parcel Flavor Body
Success 8 (1, 24, 0, 1, 1, 0)
DataInfo 71 (1, 496, 4)
With 33 (1)
PosStart 46  
Position 34 (1)
PosEnd 47  
DataInfo 71 (1, 496, 4)
EndWith 35 (1)
  • Record (1)
  • .
  • .
  • .
  • Record (23)
  • 10
  • .
  • .
  • .
  • 10
  • (ind,data)
  • .
  • .
  • .
  • (ind,data)
With 33 (1)
Record 10 (ind,data)
EndWith 35 (1)
EndStatement 11 (1)
EndRequest 12  
Select Field1 From Table1; Select Field2 From Table2; 
Parcel Flavor Body
Success 8 (1, 23, 0, 1, 1, 0)
DataInfo 71 (1, 496, 4)
  • Record (1)
  • .
  • .
  • .
  • Record (23)
  • 10
  • .
  • .
  • .
  • 10
  • (ind.data)
  • .
  • .
  • .
  • (ind.data)
EndStatement 11 (1)
Success 8 (2, 10, 0, 1, 1, 0)
DataInfo 71 (2, 496, 4)
  • Record (1)
  • .
  • .
  • .
  • Record (10)
  • 10
  • .
  • .
  • .
  • 10
  • (ind,data)
  • .
  • .
  • .
  • (data)
EndStatement 11 (2)
EndRequest 12  
Echo ‘Select Field1 From Table1’; 
Parcel Flavor Body
Success 8 (1, 0, 0, 1, 33, 0)
Record 10 (echoed string)
EndStatement 11 (1)
EndRequest 12