Req - 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.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2417
lifecycle
previous
Product Category
Teradata Tools and Utilities

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 the Database.