17.10 - 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
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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