July 30, 2010, Friday, 210


EXECUTE

From SQL PL Guide for DB2

Jump to: navigation, search

EXECUTE statement

The EXECUTE statement is executing a prepared dynamic statement. This statement required an already prepared statement by the PREPARE statement. In contrast to the EXECUTE IMMEDIATE statement the execute statement will be used when you're executing a statement multiple times.

Syntax:

EXECUTE <statement-name> [INTO <result-variable>] [USING <input-variable> [,<input-variable>,...] ]


Example:

...comming soon...

Link to the DB2 Information Center: DB2 9 DB2 9.5