Difference between revisions of "EXECUTE"

From Lianjapedia
Jump to: navigation, search
m (Text replace - "Recital" to "Lianja")
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
 
Executes an SQL statement previously set up using the PREPARE command
 
Executes an SQL statement previously set up using the PREPARE command
 
  
 
==Syntax==
 
==Syntax==
 
EXECUTE <statement> USING :<variable>[,<variable2>[,...]]
 
EXECUTE <statement> USING :<variable>[,<variable2>[,...]]
 
  
 
==See Also==
 
==See Also==
 
[[EXECUTE IMMEDIATE]], [[PREPARE]]
 
[[EXECUTE IMMEDIATE]], [[PREPARE]]
 
  
 
==Description==
 
==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.
 
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.
 
 
  
 
{| class="wikitable"
 
{| class="wikitable"
Line 26: Line 21:
 
|-
 
|-
 
|}
 
|}
 
  
 
==Example==
 
==Example==
Line 47: Line 41:
 
EXECUTE mystmt USING :buf1, :buf2, :buf3
 
EXECUTE mystmt USING :buf1, :buf2, :buf3
 
</code>
 
</code>
 
  
 
==Products==
 
==Products==

Revision as of 10:12, 11 December 2012

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 = ?'
PREPARE mystmt FROM :stmtbuf
 
gcAuthor = 'Ann Devon'
EXECUTE mystmt USING :gcAuthor
 
gcAuthor = 'Yang Wang'
EXECUTE mystmt USING :gcAuthor
 
stmtbuf = 'INSERT INTO customers (customerid, companynam, contactnam) VALUES (?,?,?)'
PREPARE mystmt FROM :stmtbuf
 
buf1 = '00101'
buf2 = 'Lianja'
buf3 = 'US'
EXECUTE mystmt USING :buf1, :buf2, :buf3

Products

Lianja Server, Lianja