Previous Topic: DescriptionNext Topic: Rules for Parameter Markers

SQL Statements › PREPARE › Rules for Statement Strings

Rules for Statement Strings

A statement string is the value of the string-expression or host-variable. A host-variable containing the statement string must be a varying-length string variable. The statement string must not begin with EXEC SQL nor end with a statement terminator, and it must not include references to host variables.

The statement string can be any of the following statements:

The statement string must not be any of the following statements:

ALTER TABLE
COMMENT ON
COMMIT WORK
CREATE
DELETE
DROP
GRANT
INSERT
LOCK TABLE
REVOKE
ROLLBACK WORK select-statement
UPDATE

CALL
CLOSE
DECLARE CURSOR
DECLARE STATEMENT
DESCRIBE
EXECUTE
EXECUTE IMMEDIATE
EXECUTE PROCEDURE
FETCH
OPEN
PREPARE
SELECT (other than the select-statement) SET CURRENT SQLID
WHENEVER