Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site

http://developer.mimer.com


EXECUTE STATEMENT


Executes a precompiled statement.

Usage

Embedded/Interactive/ODBC/JDBC

Description

The precompiled statement specified is executed. That is, the precompiled query, data manipulation, or stored procedure statement 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 adequate access rights to perform the stored command.

Examples

Interactive

 EXECUTE STATEMENT user2.seltaba
 
 EXECUTE STATEMENT updtaba

Embedded SQL

 EXEC SQL EXECUTE STATEMENT updtaba USING :hw1, :variable2

ODBC

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

Standard Compliance

Standard
Compliance
Comments
X/Open-95
SQL-92
Mimer extension
The EXECUTE STATEMENT command is a Mimer SQL extension.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Documentation TOC PREV NEXT INDEX