17.10 - Request Parcels: Overview - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

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.

The following table lists the request parcels in numerical order.

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:
  • Length
  • Type
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 database 14
  • RequestMode
  • DBCFunction
  • RFU[0] - RFU[5]
88 Connect Connects to specified server on the COP for workstation-attached systems 28 PartitionName

LogonSequenceNumber

Functions
100 Assign Request a session COP 36 UserName
106 SesInfo      
114 SessionOptions Session options 14
  • Semantics
  • Mode
  • Conformance
  • DateForm
  • ESS_Flag
  • UtilityWorkload
  • Redrive
  • ExtendedLoadUsage
  • Unused
  • Unused
120 CursorHost Provides cursor information. 18 Processor

Row

Request
123 Xindicreq   1 to 8196 Reqtxt
125 PrepInfoX   1 to Maximum parcel size
  • CostEstimate
  • SummaryCount
  • ColumnCount
  • DataType
  • DataLen
  • ColumnCharSetCode
  • ColumnExtInfo
  • ColumnName
  • ColumnFormat
  • ColumnTitle
128 Multi-TSR Segments special-purpose requests into multiple parcels 7 Sequence number

IsLast

129 SP Options Provides options for creation of a Stored Procedure. 6 Print Option

SPL Option

140 Multipart Record   2 to 32000 Data
141 End Multipart Record   2 None
142 Multipart IndicData   2 to 32000 Data
143 EndMultipart Indicdata   2 None
146 DataInfoX   6 to 32004 FieldCount

Datatype, Length pairs

148 MultiPart Request   1 to Maximum parcel size Request Text