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 SQLdev_2.0

 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