16.20 - Req - Teradata Tools and Utilities

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

prodname
Teradata Tools and Utilities
vrm_release
16.20
created_date
September 2019
category
Programming Reference
featnum
B035-2417-108K

Purpose

Initiates a request composed of one or more Teradata SQL statements and specifies that the results are to be returned in Record Mode.

Usage Notes

If the Teradata SQL request contains a USING row descriptor, then this parcel is to be followed by a Data or IndicData parcel.

This parcel is generated by CLIv2 at the direction of the application

Parcel Data

The following information applies to the Req parcel.

Flavor Parcel Body Length Parcel Body Fields
1 1 to maximum body size ReqText

Field Notes

ReqText contains the Teradata SQL request string. A request string can contain one or more Teradata SQL statements.

A single-statement request does not have to end with a semicolon.

However, if a request contains more than one statement, the statements must be separated by semicolons and the last statement does not have to end with a semicolon.

The total length of a Req parcel includes semicolons.

If the DBCAREA option Request-mode=B was specified and a request is being built that is similar to what CLIv2 builds, either the FMReq, IndicReq, MultipartRequest, or Req parcel must immediately follow any Options parcel. If no Options parcel exists, one of these must be the first parcel. The Req parcel is supported by all versions of Teradata Database.