FMReq - Call-Level Interface Version 2

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

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

FMReq

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.