EXECUTE IMMEDIATE

From Recital Documentation Wiki
Revision as of 10:46, 29 April 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Class

SQL Applications


Purpose

Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital/4GL command


Syntax

EXECUTE IMMEDIATE <statement>


See Also

DELETE, INSERT, UPDATE


Description

The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital/4GL command.


Keywords Description
statement The SQL DELETE, INSERT or UPDATE statement, or 4GL command to execute immediately.


Example

EXECUTE IMMEDIATE set deleted off;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer