Museum

Home

Lab Overview

Retrotechnology Articles

⇒ Online Manual

Media Vault

Software Library

Restoration Projects

Artifacts Sought

Related Articles

More Information

statement string

parameter

RDB/VMS SQL EXECUTE_IMMEDIATE — VMS RDB_4.2

 EXECUTE IMMEDIATE -+-> statement-string -+-> ;
                    +-> parameter --------+

Additional information available:

More Informationstatement stringparameter

More Information

 EXECUTE IMMEDIATE dynamically prepares and executes an SQL
 statement.  EXECUTE IMMEDIATE is a dynamic SQL statement and can
 be used only in precompiled programs or as part of an SQL module
 language procedure.  It cannot be used in interactive SQL.

 In EXECUTE IMMEDIATE, the SQL statement cannot be a SELECT
 statement or contain parameter markers.  However, if the
 statement meets those restrictions and will be dynamically
 executed only once, use EXECUTE IMMEDIATE instead of PREPARE and
 EXECUTE statements.

statement string

 Specifies the SQL statement to be prepared and executed
 dynamically.  You either specify the statement string directly
 in a quoted character string literal or in a parameter that
 contains the statement string.

parameter

 Specifies the SQL statement to be prepared and executed
 dynamically.  You either specify the statement string directly
 in a quoted character string literal or in a parameter that
 contains the statement string.

Typewritten Software • bear@typewritten.org • Edmonds, WA 98026