Difference between revisions of "EXEC SQL"

From Recital Documentation Wiki
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=EXEC SQL=
+
''No longer required in Recital 10''
 
+
 
+
==Class==
+
SQL Applications
+
 
+
  
 
==Purpose==
 
==Purpose==
Line 17: Line 12:
  
 
==See Also==
 
==See Also==
[[EXECUTE]], [[EXECUTE IMMEDIATE]], [[SET SQL]]
+
[[EXECUTE]], [[EXECUTE IMMEDIATE]], [[SET]], [[SET SQL]]
  
  
Line 28: Line 23:
 
set sql to recital
 
set sql to recital
 
EXEC SQL
 
EXEC SQL
select account_no from customer;
+
  SELECT account_no FROM customer;
 
</code>
 
</code>
  
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:SQL]]
 
[[Category:SQL]]
 
[[Category:Commands]]
 
[[Category:Commands]]

Latest revision as of 15:42, 5 July 2011

No longer required in Recital 10

Purpose

Indicates that the statement that follows is an SQL statement


Syntax

EXEC SQL

<statement>;


See Also

EXECUTE, EXECUTE IMMEDIATE, SET, SET SQL


Description

If SQL is set to Recital, the EXEC SQL indicates that the statement that follows it is an SQL statement.


Example

set sql to recital
EXEC SQL
  SELECT account_no FROM customer;


Products

Recital Server, Recital