Difference between revisions of "EXEC SQL"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=EXEC SQL=
 
 
 
 
==Class==
 
==Class==
 
SQL Applications
 
SQL Applications
Line 28: Line 25:
 
set sql to recital
 
set sql to recital
 
EXEC SQL
 
EXEC SQL
select account_no from customer;
+
  SELECT account_no FROM customer;
 
</code>
 
</code>
  

Revision as of 10:42, 29 April 2009

Class

SQL Applications


Purpose

Indicates that the statement that follows is an SQL statement


Syntax

EXEC SQL

<statement>;


See Also

EXECUTE, EXECUTE IMMEDIATE, 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 Database Server, Recital Mirage Server, Recital Terminal Developer