17.10 - Parcels in Normal Sequence - 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 sequence of the entire Teradata SQL response, called the spool file, as held on the database, contains a set of parcels for each Teradata SQL statement contained in it, and, last, an EndRequest parcel:

set of parcels for statement 1
set of parcels for statement 2
Ø
EndRequest Parcel

The sections that follow contain the Teradata SQL response sequences for typical Teradata SQL statements.

To discover the Teradata SQL response sequence for a Teradata SQL statement that is not included here: submit the Teradata SQL statement; call DBCHCL with the fetch function, repeatedly, to see each parcel; and stop when the EndRequest parcel is encountered.