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

Field Mode requests may return the following parcels:

 

Name

Flavor

Failure

9

Error

49

StatementError

192

OK

17

ResultSummary

171

Field

18

With

33

EndWith

35

FormatStart

22

FormatEnd

23

NullField

19

PosStart

46

Position

34

PosEnd

47

RecStart

28

RecEnd

28

SizeStart

24

Size

26

SizeEnd

25

TitleStart

20

TitleEnd

21

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

OK

17

(1, 0, 23, 3, 0, 0)

EndStatement

11

(1)

EndRequest

12

 

 

SELECT FIELD1 FROM TABLE1; 

 

 

Parcel

Flavor

Body

OK

17

(1, 1, 23, 1, 0, 0)

TitleStart

20

 

Field

18

(title)

TitleEnd

21

 

FormatStart

22

 

Field

18

(format)

FormatEnd

23

 

SizeStart

24

 

Size

26

(size)

SizeEnd

25

 

RecStart (1)

27

 

Field

18

(data)

RecEnd (1)

28

 

  .

  .

  .

 .

 .

 .

 

RecStart (23)

27

 

Field

18

(data)

RecEnd (23)

28

 

EndStatement

11

(1)

EndRequest

12

 

 

SELECT FIELD1 FROM TABLE1 WITH SUM (FIELD1)

Parcel

Flavor

Body

OK

17

(1, 1, 24, 1, 0, 0)

TitleStart

20

 

Field

18

(title)

TitleEnd

21

 

FormatStart

22

 

Field

18

(format)

FormatEnd

23

 

SizeStart

24

 

Size

26

(size)

SizeEnd

25

 

With

33

(1)

PosStart

46

 

Position

34

(1)

PosEnd

47

 

TitleStart

20

 

Field

18

(title)

TitleEnd

21

 

FormatStart

22

 

Field

18

(format)

FormatEnd

23

 

SizeStart

24

 

Size

26

(size)

SizeEnd

25

 

EndWith

35

(1)

RecStart (1)

27

 

Field

18

(data)

RecEnd (1)

28

 

  .

  .

  .

 .

 .

 .

 

RecStart (23)

27

 

Field

18

(data)

RecEnd (23)

28

 

With

33

(1)

Field

18

(data)

EndWith

35

(1)

EndStatement

11

(1)

EndRequest

12

 

 

SELECT FIELD1 FROM TABLE1; SELECT FIELD2 FROM TABLE2;

Parcel

Flavor

Body

OK

17

(1, 1, 23, 1, 0, 0)

TitleStart

20

 

Field

18

(title)

TitleEnd

21

 

FormatStart

22

 

Field

18

(format)

FormatEnd

23

 

SizeStart

24

 

Size

26

(size)

SizeEnd

25

 

RecStart (1)

27

 

Field

18

(data)

RecEnd (1)

28

 

  .

  .

 .

 .

 

RecStart (23)

27

 

Field

18

(data)

RecEnd

28

 

EndStatement

11

(1)

OK

17

(2, 1, 10, 1, 0, 0)

TitleStart

20

 

Field

18

(title)

TitleEnd

21

 

FormatStart

22

 

Field

18

(format)

FormatEnd

23

 

SizeStart

24

 

Size

26

(size)

SizeEnd

25

 

RecStart (1)

27

 

Field

18

(data)

RecEnd (1)

28

 

  .

  .

  .

 .

 .

 .

 

RecStart (10)

27

 

Field

18

(data)

RecEnd (10)

28

 

EndStatement

11

(2)

EndRequest

12

 

 

ECHO ‘SELECT FIELD1 FROM TABLE1‘;

Parcel

Flavor

Body

OK

17

(1, 1, 0, 33, 0, 0)

RecStart

27

 

Field

18

(data)

RecEnd

28

 

EndStatement

11

(1)

EndRequest

12