EXECUTE IMMEDIATE

From Recital Documentation Wiki
Revision as of 16:15, 9 December 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

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, Recital Server