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

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