FCCLOSE

The FCCLOSE command closes a forecasting context. When Oracle OLAP closes a forecasting context, only data in the variables specified in the FCEXEC command remain available to applications. Oracle OLAP purges all other data, including temporary pages, associated with the forecast.

You must use the FCCLOSE command in combination with other OLAP DML statements as outlined in "Forecasting Programs". For additional information about forecasting and forecasting methods, we suggest the latest editions of the books listed in "Further Reading on Forecasting".

Syntax

FCCLOSE handle-expression

Arguments

handle-expression

An INTEGER expression that is the handle to forecast context previously opened using the FCOPEN function.

Examples

For a full example of a forecasting program, see Example 12-10, "A Forecasting Program"..