Request Parcels: Overview
Table 7 lists the request parcels by flavor, name, and use.
Flavor |
Parcel Name |
Use |
1* |
Req |
Initiates a request (Record Mode). |
2 |
RunStartup |
Executes the user’s startup request (Record Mode). |
3* |
Data |
Contains data for a Teradata SQL request (Record Mode). |
4* |
Respond |
Requests a portion of Teradata SQL response. |
5* |
KeepRespond |
Requests a portion of Teradata SQL response without discarding response. |
7 |
Cancel |
Discards Teradata SQL response and closes Teradata SQL request; discards those segments of a segmented data request that have already been sent, for this use the parcel is described in Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems (B035-2417). |
13* |
FMReq |
Initiates a request (Field Mode). |
14 |
FMRunStartup |
Executes the user’s startup request (Field Mode). |
31 |
Rewind |
Positions spool file pointer to beginning of the spool file. |
32 |
NOP |
Performs no operation. |
36 |
Logon |
Establishes a session. |
37 |
Logoff |
Terminates a session. |
38 |
Run |
Connects to the specified partition (for DBC/1012), Applications Processor (for 3600), or node (for SMP/MPP platforms). |
68* |
IndicData |
Contains data for a Teradata SQL request (Indicator Mode). |
69* |
IndicReq |
Initiates a request (Indicator Mode). |
71* |
DataInfo |
Sends description of whichever data parcel follows it. |
72 |
IVRunStartup |
Executes the user’s startup request (Indicator Mode). |
85* |
Options |
Specifies which PREPARE options are used when a request is sent to the Teradata Database. |
88* |
Connect |
Connects to the specified partition (for DBC/1012), Applications Processor (for 3600), or node (for SMP/MPP platforms). |
114 |
SessionOptions |
Session options. |
115 |
VoteRequest |
Requests a 2PC vote. |
116 |
VoteTerm |
Requests commitment of the current 2PC transaction and returns a vote. |
117 |
Cmmt2PC |
Requests commitment of the current 2PC in‑doubt transaction. |
118 |
Abrt2PC |
Aborts the current 2PC transaction. |
120* |
CursorHost |
Provides cursor information. |
128 |
Multi-TSR |
Provides segments of a request that is too large to fit into the maximum parcel size. This parcel is currently only used for the text of Stored Procedures. |
136 |
UserNameRequest |
Requests return of the userid assigned to the session. |
137 |
UserNameResponse |
Returns the userid assigned to the session. |
140* |
MultipartData |
Contains data for an SQL request (Multipart mode). |
141* |
EndMultipartData |
End of data for a request (Multipart mode). |
142* |
MultipartIndicData |
Contains data for an SQL request (Multipart Indicator mode). |
143* |
EndMultipartIndicData |
End of data for a request (Multipart Indicator mode). |
146* |
DataInfoX |
Sends description of subsequent data parcels (Multipart mode). |
147* |
MultipartRunStartup |
Executes the user's startup request (Multipart mode). |
148* |
MultipartReq |
Initiates a request (Multipart mode). |
153* |
ExtendedRespond |
Requests a portion of Teradata SQL response. |
154* |
ExtendedKeepRespond |
Requests a portion of Teradata SQL response without discarding response. |
157* |
KeepPosition |
Requests that information be retained in the Teradata SQL response to allow positioning to a specified position. |
158 |
RowPosition |
Requests that the Teradata SQL response be repositioned to a specified row. |
159 |
OffsetPosition |
Requests that the Teradata SQL response returning a single Large-object selected by a Locator be repositioned to a specified byte or character offset. |
169* |
StatementInformation |
Describes the data items contained in the request when those attributes are not otherwise known. |
170* |
StatementInformationEnd |
Delimits StatementInformation parcels in the request. |
175 |
ResultSetCursor |
Identifies the row last fetched by an External Stored Procedure for a response being propagated to the caller or application. |
176* |
ElicitDataByName |
Indicates that data must be supplied. |
179* |
ResultSetSelection |
Indentifies which statement responses to a request from and External Stored Procedure will be propagated to the caller or application. |
189 |
ClientAttributes |
Provides descriptive information when establishing a session. |
190* |
FetchRowCount |
Specifies the maximum number of rows returned by the Database in a response buffer. |
* Parcel is described in Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems (B035-2417). |