Nonstop Database, HiRDB Version 9 UAP Development Guide
The table below shows whether pointers, structures, and structure qualifiers can be used when you specify the preprocessor's /E2 or /E3 option (-E2 or -E3 option in the UNIX edition).
A pointer refers to a variable declared with (type-name * variable-name). A structure refers to a variable declared with (struct structure-name variable-name). (However, structures that specify an SQL statement, as well as VARCHAR- and BINARY-type structures, are excluded.) A structure qualifier refers to a variable that has the (structure.member-variable-name)(structure->member-variable-name) format.
Table 8-14 Use of pointers, structures, and pointer qualifiers when the -E2 or -E3 option is specified
SQL statement that specifies embedded variable or indicator variable | Pointer | Structure | Structure qualifier | |
---|---|---|---|---|
Data manipulation SQL statement | CALL statement | Y | N | Y |
DECLARE CURSOR | Y | N | Y | |
DELETE statement | Y | N | Y | |
DESCRIBE TYPE statement | Y | N | N | |
EXECUTE statement with USING specification | Y | Y | Y | |
EXECUTE statement with INTO specification | Y | Y | Y | |
EXECUTE statement with USING specification | Y | Y | Y | |
EXECUTE statement with BY specification | Y | N | Y | |
EXECUTE IMMEDIATE statement with SQL character string location | Y | N | N | |
EXECUTE IMMEDIATE statement with INTO specification | Y | Y | Y | |
EXECUTE IMMEDIATE statement with USING specification | Y | Y | Y | |
FETCH statement with INTO specification | Y | Y | Y | |
FETCH statement with USING DESCRIPTOR specification | Y | N | Y | |
INSERT statement with VALUES specification | Y | Y | Y | |
OPEN statement | Y | N | Y | |
PREPARE statement | Y | N | N | |
SELECT statement with INTO specification | Y | Y | Y | |
UPDATE statement | Y | N | Y | |
FREE LOCATOR | Y | Y | Y | |
SET | Y | N | Y | |
ALLOCATE CURSOR | Y | N | N | |
Control SQL statement | CONNECT statement | Y | N | Y |
CONNECT statement with TO specification | Y | N | Y | |
SET SESSION AUTHORIZATION statement | Y | N | Y | |
Embedded language | GET DIAGNOSTICS | N | N | N |
COMMAND EXECUTE | N | N | N | |
INSTALL JAR | Y | N | N | |
REPLACE JAR | Y | N | N | |
REMOVE JAR | Y | N | N | |
ALLOCATE CONNECTION HANDLE | N | N | N | |
FREE CONNECTION HANDLE | N | N | N | |
DECLARE CONNECTION HANDLE SET | N | N | N | |
GET CONNECTION HANDLE | N | N | N |
All Rights Reserved. Copyright (C) 2011, Hitachi, Ltd.