17.10 - Issuing Requests: Record 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)
Record Mode requests may return the following parcels:
  • EndRequest (flavor 12)
  • EndStatement (flavor 11)
  • EndWith (flavor 35)
  • Error (flavor 49)
  • Failure (flavor 9)
  • Record (flavor 10)
  • Success (flavor 8)
  • With (flavor 33)

The following tables are examples that assume successful completion of the request. For a description of the contents of a parcel body, see Initiate-request Extensions.

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)
  • Record (1)
  • .
  • .
  • .
  • Record (23)
  • 10
  • .
  • .
  • .
  • 10
  • (data)
  • .
  • .
  • .
  • (data)
EndStatement 11 (1)
EndRequest 12  
Select Field1 from Table1 With Sum (Field1); 
Parcel Flavor Body
Success 8 (1, 24, 0, 1, 1, 0)
  • Record (1)
  • .
  • .
  • .
  • Record (23)
  • 10
  • .
  • .
  • .
  • 10
  • (data)
  • .
  • .
  • .
  • (data)
With 33 (1)
Record 10 (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)
  • Record (1)
  • .
  • .
  • .
  • Record (23)
  • 10
  • .
  • .
  • .
  • 10
  • (data)
  • .
  • .
  • .
  • (data)
EndStatement 11 (1)
Success 8 (2, 10, 0, 1, 1, 0)
  • Record (1)
  • .
  • .
  • .
  • Record (10)
  • 10
  • .
  • .
  • .
  • 10
  • (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