16.20 - FMReq - 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 specified by one or more Teradata SQL statements and specifies that the results are to be returned in Field Mode.

Usage Notes

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

Parcel Data

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

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

Field Notes

ReqText Field 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 FMReq must include 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 FMReq parcel is supported by all versions of the Database.