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.1_M

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

Additional information available:

More Informationstatement stringparameter

More Information

 EXECUTE IMMEDIATE dynamically prepares and executes an SQL
 statement.  EXECUTE IMMDEDIATE 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