8.2.8 Use of pointers, structures, and structure qualifiers when the -E2 or -E3 option of the preprocessor is specified

Table 8-14 shows whether or not pointers, structures, and pointer qualifiers can be used when you specify the preprocessor's /E2 or /E3 option (-E2 or -E3 option in the UNIX version).

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 variablePointerStructureStructure qualifier
Data manipulation SQL statementCALL statementYNY
DECLARE CURSORYNY
DELETE statementYNY
DESCRIBE TYPE statementYNN
EXECUTE statement with USING specificationYYY
EXECUTE statement with INTO specificationYYY
EXECUTE statement with USING specificationYYY
EXECUTE statement with BY specificationYNY
EXECUTE IMMEDIATE statement with SQL character string locationYNN
EXECUTE IMMEDIATE statement with INTO specificationYYY
EXECUTE IMMEDIATE statement with USING specificationYYY
FETCH statement with INTO specificationYYY
FETCH statement with USING DESCRIPTOR specificationYNY
INSERT statement with VALUES specificationYYY
OPEN statementYNY
PREPARE statementYNN
SELECT statement with INTO specificationYYY
UPDATE statementYNY
FREE LOCATORYYY
SETYNY
ALLOCATE CURSORYNN
Control SQL statementCONNECT statementYNY
CONNECT statement with TO specificationYNY
SET CONNECTION statementYNY
SET SESSION AUTHORIZATION statementYNY
Embedded languageGET DIAGNOSTICSNNN
COMMAND EXECUTENNN
INSTALL JARYNN
REPLACE JARYNN
REMOVE JARYNN
ALLOCATE CONNECTION HANDLENNN
FREE CONNECTION HANDLENNN
DECLARE CONNECTION HANDLE SETNNN
GET CONNECTION HANDLENNN
Legend:
Y: Can be specified.
N: Cannot be specified.