Difference between revisions of "EXECUTE IMMEDIATE"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
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 command
  
  
Line 12: Line 12:
  
 
==Description==
 
==Description==
The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital/4GL command.
+
The EXECUTE IMMEDIATE command is used to prepare and execute immediately a DELETE, INSERT, or UPDATE SQL statement or any Recital command.
  
  
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.
 
|-
 
|-
 
|}
 
|}
Line 26: Line 26:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
EXECUTE IMMEDIATE set deleted off;
+
EXECUTE IMMEDIATE set deleted off
 
</code>
 
</code>
  

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