Request Parcels: Overview - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Request Parcels: Overview

The application program arranges for request parcels to be generated but does not view them directly if the Request Mode is Parcel Mode and a DBCAREAX is not being used. If a DBCAREAX is being used, then the application builds parcels directly in the DBCAREAX.

If Request Mode is Buffer Mode, then parcels are built directly in the Request buffer.

Table 14 lists, in numerical order, the request parcels.

 

Table 14: Request Parcels 

Parcel

Flavor

Parcel Name

Parcel Use

Parcel

Length

Fields in Parcel Body

1

Req

Initiates a request

5-12504

ReqText

2

RunStartup

Executes the user’s startup request

4

None

3

Data

Contains data for a Teradata SQL request

5-32004/65104

Data

4

Resp

Request portion of Teradata SQL response

6

MaxMsgSize

5

KeepResp

Requests a portion of Teradata SQL response without discarding response

6

MaxMsgSize

6

Abort

Attempts to abort a request

4

None

7

Cancel

Discards Teradata SQL response and closes Teradata SQL request; discards those segments of a segmented data request that have already been sent.

4

None

13

FMReq

Initiates a request

5-12504

ReqText

14

FMRunStartup

Executes the user’s startup request

4

None

31

Rewind

Positions spool file pointer to beginning of the spool file

4

None

36

Logon

Establishes a session

132

LogonString

37

Logoff

Terminates a session

4

None

38

Run

Connects to specified server on the COP for workstation-attached clients or to the specified IFP partition for mainframe‑ attached systems

20

PartitionName

42

Config

 

 

 

68

IndicData

Contains data for a Teradata SQL request

6-32004/65104

NullIndic Data

69

IndicReq

Initiates a request

5-12504

ReqText

71

DataInfo

Sends description of whichever data parcel follows it

6-32004/65104

FieldCount Groups:
 Length
 Type

72

IVRunStartup

Executes the user’s startup request

4

None

85

Options

Specified which PREPARE options are used when a request is sent to the Teradata Database

14

RequestMode
DBCFunction
RFU[0] - RFU[5]

88

Connect

Connects to specified server on the COP for workstation-attached systems

28

PartitionName
LogonSequenceNumber
Functions

100

Assign

Request a session COP

36

UserName

106

SesInfo

 

 

 

114

SessionOptions

Session options

14

Semantics
Mode
Conformance
DateForm
ESS_Flag
UtilityWorkload
Unused
ExtendedLoadUsage

120

CursorHost

Provides cursor information.

18

Processor
Row
Request

123

Xindicreq

 

1 to 8196

Reqtxt

125

PrepInfoX

 

1 to Maximum
parcel size

CostEstimate
SummaryCount
ColumnCount
DataType
DataLen
ColumnCharSetCode
ColumnExtInfo
ColumnName
ColumnFormat
ColumnTitle

128

Multi-TSR

Segments special-purpose requests into multiple parcels

7

Sequence number
IsLast

129

SP Options

Provides options for creation of a Stored Procedure.

6

Print Option
SPL Option

140

Multipart
Record

 

2 to 32000

Data

141

End Multipart
Record

 

2

None

142

Multipart
IndicData

 

2 to 32000

Data

143

EndMultipart
Indicdata

 

2

None

146

DataInfoX

 

6 to 32004

FieldCount
Datatype, Length pairs

148

MultiPart
Request

 

1 to Maximum
parcel size

Request Text