Issuing Requests—Indicator Mode - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

Issuing Requests—Indicator Mode

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 Chapter 15: “Parcels for Basic Applications” or Chapter 16: “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