ALTER STATEMENT

Recompile a stored statement.

 

Usage

Embedded, Interactive, Module, 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