Parcel Types - Teradata Director Program

There are two parcel types:

Request which are sent to the Teradata Database
Response which are sent from the Teradata Database

The two parcel types are described below.

Request Parcels: Overview

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 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 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	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).

Response Parcels: Overview

Response Parcel Flavors, Names, and Uses
Flavor	Parcel Name	Use
8*	Success	Indicates that the specified Teradata SQL statement completed successfully in other than Field Response-mode. When the response is for a session that specified a SessionOptions parcel (described in SessionOptions) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) may be returned instead.
9*	Failure	Indicates that the specified statement has failed and the entire transaction was rolled back. When the response is for a session that specified a SessionOptions parcel (described in SessionOptions) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) may be returned instead.
10*	Record (Record Mode)	Returns one row of selected results.
10*	Record (Indicator Mode)	Returns one row of selected results.
11*	EndStatement	Delimits the end of the results from the specified Teradata SQL statement.
12*	EndRequest	Delimits the end of a Teradata SQL response to a Teradata SQL request.
17*	Ok	Indicates that the specified Teradata SQL statement completed successfully in Field Response-mode. When the response is for a session that specified a SessionOptions parcel (described in SessionOptions) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) may be returned instead.
18*	Field	Contains returned information (data value, title, format, or echo).
19*	NullField	Returns a null data value for a field.
20*	TitleStart	Delimits the start of a set of Title parcels.
21*	TitleEnd	Delimits the end of a set of Title parcels.
22*	FormatStart	Delimits the start of a set of format-containing Field parcels.
23*	FormatEnd	Delimits the end of a set of format-containing Field parcels.
24*	SizeStart	Delimits the start of a set of Size parcels.
25*	SizeEnd	Delimits the end of a set of Size parcels.
26*	Size	Specifies the width of a column of selected results.
27*	RecStart	Delimits the start of a set of data-value-containing Field and Null-Field parcels or a set of echoed string- containing Field parcels.
28*	RecEnd	Delimits the end of a set of data-value-containing Field and Null-Field parcels or a set of echoed string-containing Field parcels.
33*	With	Delimits the start of a set of parcels for the specified WITH clause.
34*	Position	Specifies the column number being summarized.
35*	EndWith	Delimits the end of a set of parcels for the specified WITH clause.
46*	PosStart	Delimits the start of a set of Position parcels.
47*	PosEnd	Delimits the end of a set of Position parcels.
49*	Error	Indicates that the specified statement has an error not serious enough to cause rollback. When the response is for a session that specified a SessionOptions parcel (described in SessionOptions) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) may be returned instead.
71*	DataInfo	Returns a description of the following Indicator Mode Record parcels.
86*	PrepInfo	Returns column information from the Teradata Database when a Teradata SQL statement has been sent with a Request Processing Option of Prepare and a Response Mode of Indicator.
121*	CursorDBC	Returns cursor information.
122*	Flagger	Returns language non-conformances.
125*	PrepInfoX	Returns column information from the Teradata Database when a Teradata SQL statement has been sent with a Request Processing Option of Prepare and a Response Mode of Extended.
137	UserNameResponse	Returns the userid assigned to the session.
144*	MultipartRecord	Returns selected results (Multipart mode).
145*	EndMultipartRecord	Indicates end of selected results for one row (Multipart mode).
146*	DataInfoX	Returns a description of subsequent parcels (Multipart mode).
150*	ElicitData	Indicates that data must be supplied.
151*	ElicitFile	Indicates that the contents of a file must be supplied.
152*	ElicitDataReceived	Indicates that elicited data was received by the Teradata Database.
164*	ErrorInformation	After an Error parcel (flavor 49), provides additional information about the error. When the response is for a session that specified a SessionOptions parcel (described in SessionOptions) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) may be returned instead.
169*	StatementInformation	Returns a description of the data, when the Options parcel (flavor 85 in Request Parcels: Overview) specifies Return-statement-info (corresponding to the CLIv2 DBCAREA Return-statement-info option)
170*	Statement InformationEnd	Delimits related StatementInformation parcels.
172*	ResultSet	Introduce parcels returned from a CALLed stored procedure
176*	ElicitDataByName	Indicates that data must be supplied for the specified name.
192*	StatementError	Indicates a statement in a multi-statement request encountered a problem but the transaction is not rolled back. When the response is for a session that specified a SessionOptions parcel (described in SessionOptions) with a StatementStatus option other than “O”, a StatementStatus parcel (flavor 205 in Parcel Flavors) may be returned instead.
205*	StatementStatus	Indicates that the specified Teradata SQL statement completed.
220*	SLOB DataStart	Introduces SLOB Data parcels.
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).