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 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 CONNECTION statement	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

Legend:

Y: Can be specified.

N: Cannot be specified.