17.10 - Request Pointer - Call-Level Interface Version 2

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

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

Usage Notes

The Request Pointer field specifies the address of the request string.

Language Variable Name
COBOL: DBCAREA-REQ-PTR
C: DBCAREA.H: req_ptr
Routine Action Taken
DBCHINI: writes
DBCHCL: reads (IRQ)
Used by Action Taken
application program writes

Before calling DBCHCL for the Initiate Request function, the application program must build a request string, such as a Teradata SQL request.

If Variable Length Request is set to:
  • N, Request Pointer must contain the address of the beginning of the request string.
  • Y, Request Pointer must contain the address of the two-byte length field immediately preceding the request string. See Variable Length Request.

The request string should not be enclosed in apostrophes. If there is more than one statement in the request, a semicolon must separate the statements. A semicolon after the last statement in the request is optional.

If a USING modifier is included in the Teradata SQL request, the USING modifier must be the very first clause in the request. The USING modifier names and describes each field of the data pointed to by Using Data Pointer, in positional sequence. Each field name may be referred to any number of times in any number of statements in that request, including the case of no references to that name.