EXECUTE IMMEDIATE

This SQL statement can be executed in the following ways:	Through the CA Datacom Datadictionary Interactive SQL Service Facility (interactive)	In an application program prepared using a CA Datacom/DB SQL Preprocessor (embedded)	By using CA Dataquery (SQL & Batch Modes)
EXECUTE IMMEDIATE		YES

Note: YES indicates a valid execution method for this statement.

The EXECUTE IMMEDIATE statement prepares and executes an SQL statement. EXECUTE IMMEDIATE is more convenient than using PREPARE and EXECUTE, but note the following:

With EXECUTE IMMEDIATE, parameter markers cannot be used, and
EXECUTE IMMEDIATE is less efficient than using PREPARE and EXECUTE, which allow you to prepare a statement once and execute it multiple times.

No authorization is required to preprocess an EXECUTE IMMEDIATE statement, that is, there is no security check of the EXECUTE IMMEDIATE statement or its contents at preprocessor time. At execution time, however, the statement's contents are checked against the security conditions that are valid for that program.

Following is the syntax diagram for the EXECUTE IMMEDIATE statement:

►►─ EXECUTE IMMEDIATE ─┬─ string-expression ─┬────────────────────────────────►◄
                       └─ host-variable ─────┘