Difference between revisions of "EXECUTE IMMEDIATE"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 19: Line 19:
 
!Keywords||Description
 
!Keywords||Description
 
|-
 
|-
|statement||The SQL DELETE, INSERT or UPDATE statement, or 4GL command to execute immediately.
+
|statement||The SQL DELETE, INSERT or UPDATE statement, or Recital command to execute immediately.
 
|-
 
|-
 
|}
 
|}

Latest revision as of 11:29, 24 December 2009

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 Recital command to execute immediately.


Example

EXECUTE IMMEDIATE set deleted off


Products

Recital, Recital Server