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
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-01
dita:mapPath
ggf1488824663364.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities
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