Examples - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems - 20.00
Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
Call-Level Interface Version 2
Release Number
20.00
Published
January 2024
ft:locale
en-US
ft:lastEdition
2024-11-15
dita:mapPath
bmn1691484839905.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
fvz1470444150352
lifecycle
latest
Product Category
Teradata Tools and Utilities

The following examples assume successful completion of the request.

Example 1

UPDATE TABLE1 SET FIELD1 999999

Parcel Flavor Parcel Body Fields
Success 8 (1, 23, 0, 0, 3, 0)
EndStatement 11 (1)
EndRequest    

Example 2

Select field1 from table1

Parcel Flavor Parcel Body Fields
Success 8 (1, 23, 0, 0, 3, 0)
DataInfox 146 (1, 496, 4)
Multipart record for row 1 144 (indicator, data)
End Multipart Record 145  
Multipart record for row 2 144 (indicator, data)
End Multipart Record 145  
End Statement 11  
End Request 10  

Example 3

SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1);

Parcel Flavor Parcel Body Fields
Success 8 (1, 23, 0, 0, 3, 0)
DataInfox 146 (1, 496, 4)
With 33 (1)
PosStart 46  
Position 34 1
PosEnd 47  
DataInfox 146 (1, 496, 4)
EndWith 35 (1)
Multipart record for row 1 144 (indicator, data)
End Multipart Record 145  
Multipart record for row 2 144 (indicator, data)
End Multipart Record 145  
with 33 (1)
Multipart record 144 (indicator, data)
End Multipart Record 145  
EndWith 35 (1)
End Statement 11 (1)
End Request 10  

Example 4

SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2;

Parcel Flavor Parcel Body Fields
Success 8 (1, 23, 0, 0, 3, 0)
DataInfox 146 (1, 496, 4)
Multipart record for row 1 144 (indicator, data)
End Multipart Record 145  
Multipart record for row 2 144 (indicator, data)
End Multipart Record 145  
End Statement 11  
Success 8 (1, 23, 0, 0, 3, 0)
DataInfox 146 (1, 496, 4)
Multipart record for row 1 144 (indicator, data)
End Multipart Record 145  
Multipart record for row 2 144 (indicator, data)
End Multipart Record 145  
End Statement 11 (1)
End Request 10  

Example 5

ECHO “SELECT FIELD1 FROM TABLE1”

Parcel Flavor Parcel Body Fields
Success 8 (1, 0, 0, 1, 33, 0)
Multipart record(s) 144 (ind, data)
EndMultipartRecord 145  
End Statement 11 (1)
End Request 10