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.
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: |
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 |
88 |
Connect |
Connects to specified server on the COP for workstation-attached systems |
28 |
PartitionName |
100 |
Assign |
Request a session COP |
36 |
UserName |
106 |
SesInfo |
|
|
|
114 |
SessionOptions |
Session options |
14 |
Semantics |
120 |
CursorHost |
Provides cursor information. |
18 |
Processor |
123 |
Xindicreq |
|
1 to 8196 |
Reqtxt |
125 |
PrepInfoX |
|
1 to Maximum |
CostEstimate |
128 |
Multi-TSR |
Segments special-purpose requests into multiple parcels |
7 |
Sequence number |
129 |
SP Options |
Provides options for creation of a Stored Procedure. |
6 |
Print Option |
140 |
Multipart |
|
2 to 32000 |
Data |
141 |
End Multipart |
|
2 |
None |
142 |
Multipart |
|
2 to 32000 |
Data |
143 |
EndMultipart |
|
2 |
None |
146 |
DataInfoX |
|
6 to 32004 |
FieldCount |
148 |
MultiPart |
|
1 to Maximum |
Request Text |