15.10 - Issuing Requests—MultipartIndicator 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

MultipartIndicator Mode requests may return the following parcels:

 

Name

Flavor

Failure

9

Error

49

StatementError

192

Success

8

StatementStatus

205

DataInfoX

146

MultipartRecord

144

StatementInformation

169

StatementInformationEnd

170

EndMultipartRecord

145

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

 

 

UPDATE TABLE1 SET FIELD1 = 999999

Parcel

Flavor

Body

Success

8

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

DataInfoX

146

(1, 496, 4)

MultipartRecord(s) for row 1

144

(ind, data)

EndMultipartRecord

145

(ind, data)

MultipartRecord(s) for row 23

144

(ind, data)

EndMultipartRecord

145

(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)

DataInfoX

146

(1, 496, 4)

With

33

(1)

PosStart

46

 

Position

34

(1)

PosEnd

47

 

DataInfoX

146

(1, 496, 4)

EndWith

35

(1)

MultipartRecord(s) for row 1

144

(ind, data)

EndMultipartRecord

145

 

MultipartRecord (s)for row 23

144

(ind, data)

EndMultipartRecord

145

 

With

33

(1)

MultipartRecord(s)

144

(ind,data)

EndMultipartRecord

145

 

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)

DataInfoX

146

(1, 496, 4)

MultipartRecord(s) for row 1

144

(ind, data)

EndMultipartRecord

145

 

MultipartRecord(s) for row 23

144

(ind, data)

EndMultipartRecord

145

 

EndStatement

11

(1)

Success

8

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

DataInfoX

71

(2, 496, 4)

MultipartRecord(s) for row 1

144

(ind, data)

EndMultipartRecord

145

 

MultipartRecord(s) for row 10

144

(ind, data)

EndMultipartRecord

145

 

EndStatement

11

(2)

EndRequest

12

 

 

ECHO ‘SELECT FIELD1 FROM TABLE1‘;

Parcel

Flavor

Body

Success

8

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

MultipartRecord(s)

144

(ind, data)

EndMultipartRecord

145

 

EndStatement

11

(1)

EndRequest

12