Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


ALTER STATEMENT


Recompile a stored statement.



Usage

Embedded/Interactive/ODBC/JDBC.

Description

The compiled form of the precompiled statement is replaced with the result of a new compilation.

Restrictions

It is only the creator of the statement that may alter it.

Notes

The use for this statement is diminished since automatic statement refresh has been implemented. That is, when creating or dropping an index for a table, all statements using that table are automatically refreshed. Likewise, UPDATE STATISTICS for a table will also cause a rebuild of statements using that table.

One case where this statement still is useful is after DELETE STATISTICS which will not cause an automatic refresh of statements.

Example

 ALTER STATEMENT seltaba REFRESH;

Standard Compliance

Standard
Compliance
Comments

Mimer SQL extension
The ALTER STATEMENT statement is a Mimer SQL extension.


Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX