Table 9 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. |
|
215* |
SLOB Response |
Allows the Teradata Database to return data for a LOB inline based on specified limits. |
|
220* |
SLOB DataStart |
Introduces SLOB Data parcels for a LOB. |
|
221* |
SLOB Data |
Provides data for a LOB. |
|
222* |
SLOB DataEnd |
Ends SLOB Data parcels for a LOB. |
|
* Parcel is described in Teradata Call-Level Interface Version 2 Reference for Mainframe-Attached Systems (B035-2417). |
||