Difference between revisions of "PREPARE"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=PREPARE=
 
 
 
==Class==
 
SQL Applications
 
 
 
 
==Purpose==
 
==Purpose==
 
Set up an SQL statement for subsequent execution
 
Set up an SQL statement for subsequent execution

Revision as of 12:49, 26 October 2009

Purpose

Set up an SQL statement for subsequent execution


Syntax

PREPARE <statement> FROM :<variable>


See Also

EXECUTE, EXECUTE IMMEDIATE


Description

The PREPARE command is used to set up an SQL statement for subsequent execution. The EXECUTE command is used to execute the statement. Variables used as parameters in the SQL statement must be declared before execution.


Keywords Description
statement An identifier for the SQL statement.
variable The name of a variable containing the SQL statement as a string


Example

stmtbuf = 'SELECT * FROM customers WHERE contactnam = ?'
exec sql
prepare mystmt from :stmtbuf;
 
gcAuthor = 'Ann Devon'
exec sql
execute mystmt using :gcAuthor;
 
gcAuthor = 'Yang Wang'
exec sql
execute mystmt using :gcAuthor;
 
stmtbuf = 'INSERT INTO customers (customerid, companynam, contactnam) VALUES (?,?,?)'
exec sql
prepare mystmt from :stmtbuf;
 
buf1 = '00101'
buf2 = 'Recital'
buf3 = 'US'
exec sql
execute mystmt using :buf1, :buf2, :buf3;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer