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 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 Information Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 info@mimer.se