15.10 - Issuing Requests—Record Mode - Call-Level Interface Version 2

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

prodname
Call-Level Interface Version 2
vrm_release
15.10
category
Programming Reference
featnum
B035-2417-035K

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