16.20 - Issuing Requests—MultipartIndicator Mode - Teradata Tools and Utilities

Teradata® Call-Level Interface Version 2 Reference for Mainframe-Attached Systems

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

MultipartIndicator Mode requests may return the following parcels:

Name Flavor
Failure 9
Error 49
StatementError 192
Success 8
StatementStatus 205
DataInfoX 146
MultipartRecord 144
StatementInformation 169
StatementInformationEnd 170
EndMultipartRecord 145
With 33
EndWith 35
PosStart 46
Position 34
PosEnd 47
EndStatement 11
EndRequest 12

The following examples assume successful completion of the request when using Original Statement-status. If using Enhanced Statement-status, OK parcels may be replaced by StatementStatus parcels. See Parcels for Basic Applications or Parcels for Advanced Applications for detailed descriptions of parcels.

The following examples assume that the Return-statement-info 'Y' option was not specified; if specified, DataInfoX parcels will be replaced by StatementInformation and StatementInformationEnd parcels.

UPDATE TABLE1 SET FIELD1 = 999999
Parcel Flavor Body
Success 8 (1, 23, 0, 0, 3, 0)
EndStatement 11 (1)
EndRequest 12  
UPDATE TABLE1 SET FIELD1 = 999999
Parcel Flavor Body
Success 8 (1, 23, 0, 1, 1, 0)
DataInfoX 146 (1, 496, 4)
MultipartRecord(s) for row 1 144 (ind, data)
EndMultipartRecord 145 (ind, data)
MultipartRecord(s) for row 23 144 (ind, data)
EndMultipartRecord 145 (ind, data)
EndStatement 11 (1)
EndRequest 12  
SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1);
Parcel Flavor Body
Success 8 (1, 24, 0, 1, 1, 0)
DataInfoX 146 (1, 496, 4)
With 33 (1)
PosStart 46  
Position 34 (1)
PosEnd 47  
DataInfoX 146 (1, 496, 4)
EndWith 35 (1)
MultipartRecord(s) for row 1 144 (ind, data)
EndMultipartRecord 145  
MultipartRecord (s)for row 23 144 (ind, data)
EndMultipartRecord 145  
With 33 (1)
MultipartRecord(s) 144 (ind,data)
EndMultipartRecord 145  
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)
DataInfoX 146 (1, 496, 4)
MultipartRecord(s) for row 1 144 (ind, data)
EndMultipartRecord 145  
MultipartRecord(s) for row 23 144 (ind, data)
EndMultipartRecord 145  
EndStatement 11 (1)
Success 8 (2, 10, 0, 1, 1, 0)
DataInfoX 71 (2, 496, 4)
MultipartRecord(s) for row 1 144 (ind, data)
EndMultipartRecord 145  
MultipartRecord(s) for row 10 144 (ind, data)
EndMultipartRecord 145  
EndStatement 11 (2)
EndRequest 12  
ECHO ̀SELECT FIELD1 FROM TABLE1́;
Parcel Flavor Body
Success 8 (1, 0, 0, 1, 33, 0)
MultipartRecord(s) 144 (ind, data)
EndMultipartRecord 145  
EndStatement 11 (1)
EndRequest 12