EXECUTE

Purpose

Executes an SQL statement previously set up using the PREPARE command

Syntax

EXECUTE <statement> USING :<variable>[,<variable2>[,...]]

See Also

EXECUTE IMMEDIATE, PREPARE

Description

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

Keywords	Description
statement	An identifier for the SQL statement previously set up using PREPARE
variable	The name of a variable to be used as the first parameter to the SQL statement
variable2...	The names of variables to be used as the subsequent parameters to the SQL statement

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 Server, Recital