Difference between revisions of "PREPARE"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==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
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
