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

Indicator Mode requests may return the following parcels:

Name Flavor
Failure 9
Error 49
StatementError 192
Success 8
StatementStatus 205
DataInfo 71
StatementInformation 169
StatementInformationEnd 170
Record 10
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  
SELECT FIELD1 FROM TABLE1;    
Parcel Flavor Body
Success 8 (1, 23, 0, 1, 1, 0)
DataInfo

(continued)

71 (1, 496, 4)
Record (1)

  .

  .

  .

Record (23)

10

 .

 .

 .

10

(ind, data)

 .

 .

 .

(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)
DataInfo 71 (1, 496, 4)
With 33 (1)
PosStart 46  
Position 34 (1)
PosEnd 47  
DataInfo 71 (1, 496, 4)
EndWith 35 (1)
Record (1) 10 (ind,data)
  .  .  .
  .

  .

 .

 .

 .

 .

Record (23) 10 (ind,data)
With 33 (1)
Record 10 (ind,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)
DataInfo 71 (1, 496, 4)
Record (1)

  .

  .

  .

Record (23)

10

 .

 .

 .

10

(ind.data)

 .

 .

 .

(ind,data)

EndStatement 11 (1)
Success 8 (2, 10, 0, 1, 1, 0)
DataInfo 71 (2, 496, 4)
Record (1)

  .

  .

  .

Record (10)

10

 .

 .

 .

10

(ind,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