EXECUTE STATEMENT

Executes a precompiled statement.

execute_statement.png

 

Usage

Embedded/Interactive/Module/ODBC/JDBC

Description

The precompiled statement specified is executed. That is, the precompiled statement identified by statement-name is executed.

In dynamic SQL the application can inquire about the type of statement and information about input and output host variables. I.e. the precompiled statement is handled like any other statement where the actual content of the SQL statement is not known.

A precompiled statement belongs to a schema.

Restrictions

The ident executing the EXECUTE STATEMENT command must have execute privilege on the precompiled statement.

Examples

Interactive

EXECUTE STATEMENT user2.seltaba;

 

updtaba;

Embedded SQL

exec sql EXECUTE STATEMENT user2.seltaba;

 

exec sql updtaba;

ODBC

SQLPrepare(hStmt, "EXECUTE STATEMENT user2.seltaba", SQL_NTS);

Standard Compliance

Standard

Compliance

Comments

 

Mimer SQL extension

The EXECUTE STATEMENT command is a Mimer SQL extension.