Difference between revisions of "EXECUTE IMMEDIATE"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 1: Line 1:
=EXECUTE IMMEDIATE=
 
 
 
 
==Class==
 
==Class==
 
SQL Applications
 
SQL Applications

Revision as of 10:46, 29 April 2009

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