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:
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;