Difference between revisions of "EXECUTE IMMEDIATE"

From Recital Documentation Wiki
Jump to: navigation, search
(Class)
Line 1: Line 1:
 
 
 
==Purpose==
 
==Purpose==
 
Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital/4GL command
 
Prepares and executes immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital/4GL command
Line 33: Line 31:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Revision as of 16:15, 9 December 2009

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