Examples - 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
Published
October 2021
Language
English (United States)
Last Update
2021-11-02
dita:mapPath
ttt1608578409164.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2418
lifecycle
previous
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