Issuing Requests—Indicator Mode - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
16.20
Published
September 2019
Language
English (United States)
Last Update
2019-10-12
dita:mapPath
dsu1527114222346.ditamap
dita:ditavalPath
dsu1527114222346.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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