FMReq - Teradata Tools and Utilities

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

Product
Teradata Tools and Utilities
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
lvt1544831946862.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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.