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
15.00
Language
English (United States)
Last Update
2018-09-25
dita:id
B035-2418
lifecycle
previous
Product Category
Teradata Tools and Utilities

Request Pointer

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” on page 172.
  • 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.

    Note: 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.

    Example  

    Note: The following is an example of a valid request:

    USING x1 (INTEGER), x2 (CHAR (2) )
    SELECT * FROM t1 WHERE c1 = :x2;
    SELECT * FROM t2 WHERE c2 = :x2;