16.20 - Issuing Requests—Record 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

Record Mode requests may return the following parcels:

Name Flavor
Failure 9
Error 49
StatementError 192
Success 8
StatementStatus 205
Record 10
With 33
EndWith 35
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.

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