Parcel Structure - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Parcel Structure

There are two parcel header formats:

  • Standard Parcel Header (SPH)
  • Alternate Parcel Header (APH)
  • The maximum length of an SPH parcel is 65,535 bytes; the maximum length of an APH parcel is ~1 MB.

    Note: A parcel using the APH will be 4-bytes larger than a parcel using the SPH.

    The format of the SPH shown in Figure 4.

    Figure 4: SPH Parcel Format

    Note: A maximum parcel body size of 65,104 bytes is only approached with the Archive/Recovery utility. The maximum size of a regular SQL parcel body is 64,260 bytes, including overhead such a presence bits and variable length columns.

    The format of the APH is shown in Figure 5.

    Figure 5: APH Parcel Format

    The two types of parcel headers may be intermixed in the same request or response. Parcels whose length is less than or equal to 65,535 may use either header format.

    Note: A response will only contain a parcel using APH if the APH‑response‑permitted option was specified and the Teradata Database supports the alternate header for that parcel.

    Note: dbcarea.consider_APH_resps must be set to ‘Y’ to receive APH responses.