EXECUTE IMMEDIATE

From Recital Documentation Wiki
Revision as of 15:54, 22 December 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Purpose

Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital 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 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, Recital Server