Request Parcels: Overview - Teradata Director Program

Teradata® Director Program Reference

Product
Teradata Director Program
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
pxm1544831938750.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2416
lifecycle
previous
Product Category
Teradata Tools and Utilities
Request Parcel Flavors, Names, and Uses 
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 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 Two-phase commit vote.
116 VoteTerm Requests commitment of the current Two-phase commit transaction and returns a vote.
117 Cmmt2PC Requests commitment of the current Two-phase commit in-doubt transaction.
118 Abrt2PC Aborts the current Two-phase commit 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 Identifies 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 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.