15.10 - Response Parcels: Overview - 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

Response parcels are generated by the Teradata Database in response to an application's request. Not every parcel appears in every response.

The following table lists the response parcels by flavor, name, use, length, and the names of fields contained in the parcel body.

 

Table 64: Response Parcel Flavors, Names, And Uses 

Flavor

Parcel Name

Use

8

Success

Indicates that the specified Teradata SQL statement completed successfully in other than Field Responsemode when using Original Statementstatus.

9

Failure

Indicates that the specified statement has failed and the entire transaction was rolled back.

10

Record

(Record Mode)

Returns one row of selected results.

10

Record

(Indicator Mode)

Returns one row of selected results.

11

EndStatement

Delimits the end of the results from the specified Teradata SQL statement.

12

EndRequest

Delimits the end of a Teradata SQL response to a Teradata SQL request.

17

OK

Indicates that the specified Teradata SQL statement completed successfully (Field Mode) in Field Responsemode when using Original Statementstatus.

18

Field

Contains returned information (data value, title, format, or echo).

19

NullField

Returns a null data value for a field.

20

TitleStart

Delimits the start of a set of Title parcels.

21

TitleEnd

Delimits the end of a set of Title parcels.

22

FormatStart

Delimits the start of a set of format‑containing Field parcels.

23

FormatEnd

Delimits the end of a set of format‑containing Field parcels.

24

SizeStart

Delimits the start of a set of Size parcels.

25

SizeEnd

Delimits the end of a set of Size parcels.

26

Size

Specifies the width of a column of selected results.

27

RecStart

Delimits the start of a set of data‑valuecontaining Field and Null‑Field parcels or a set of echoed string‑ containing Field parcels.

28

RecEnd

Delimits the end of a set of data‑valuecontaining Field and Null‑Field parcels or a set of echoed string‑containing Field parcels.

33

With

Delimits the start of a set of parcels for the specified WITH clause, when Returnstatementinfo 'Y' was not specified.

34

Position

Specifies the column number being summarized, when Returnstatementinfo 'Y' was not specified.

35

EndWith

Delimits the end of a set of parcels for the specified WITH clause, when Returnstatementinfo 'Y' was not specified.

46

PosStart

Delimits the start of a set of Position parcels, when Returnstatementinfo 'Y' was not specified.

47

PosEnd

Delimits the end of a set of Position parcels, when Returnstatementinfo 'Y' was not specified.

49

Error

Indicates that the specified statement has an error not serious enough to cause rollback.

71

DataInfo

Returns a description of the following Indicator Mode Record parcels, when Returnstatementinfo 'Y' was not specified.

86

PrepInfo

Returns column information from the Teradata Database when a Teradata SQL statement has been sent with a Request Processing Option of Prepare and a Response Mode of Indicator, when Returnstatementinfo 'Y' was not specified.

122

Flagger

Returns language nonconformances.

125

PrepInfoX

Returns column information from the Teradata Database when a Teradata SQL statement has been sent with a Request Processing Option of Prepare and a Response Mode of MultiportIndicator, when Returnstatementinfo 'Y' was not specified.

144

MultipartRecord

For MultipartIndicator mode responses, returns one row or part of one row of selected results.

145

EndMultipartRecord

For MultipartIndicator mode responses, delimits one row or selected results.

146

DataInfoX

For MultipartIndicator mode responses, describes the data contained in subsequent MultipartRecord parcels, when Returnstatementinfo 'Y' was not specified.

150

ElicitData

For MultipartIndicator mode responses, elicits a deferred MultipartIndicator response mode large object.

151

ElicitFile

For MultipartIndicator mode responses, elicits a User Defined Function.

152

ElicitDataReceived

For MultipartIndicator mode responses, indicates that an elicited data or file was successfully received.

164

ErrorInformation

After an Error parcel (flavor 49), provides additional information about the error

169

StatementInformation

Returns a description of the data, when Returnstatementinfo 'Y' was specified.

170

StatementInformationEnd

Delimits related StatementInformation parcels.

171

ResultSummary

Indicates that the specified Teradata SQL statement completed successfully when using Enhanced Statementstatus.

172

ResultSet

Introduce parcels returned from a CALLed stored procedure.

176

ElicitDataByName

For MultipartIndicator mode responses, elicits a deferred large object by its specified name.

192

StatementError

Indicates a statement in a multi-statement request encountered a problem but the transaction is not rolled back.

205

StatementStatus

Indicates that the specified Teradata SQL statement completed.