10
DBMS_AW

This chapter contains reference information for the DBMS_AW package. Using the procedures and functions in the DBMS_AW package, SQL programmers can issue OLAP DML statements against analytic workspace data. They can move data from relational tables into the analytic workspace, perform advanced analysis (for example, forecasting), and move data from the analytic workspace back into relational tables. Also, once the data is in the analytic workspace, SQL programmers can issue SELECT statements against the data in the analytic workspace using the OLAP_TABLE function.

The DBMS_AW package also includes procedures and functions that SQL programmers can use to retrieve and print the session logs created by the execution of the OLAP_TABLE function or the procedures and functions in the DBMS_AW package.

This chapter includes the following topics:

• Summary of DBMS_AW Subprograms
• EXECUTE Procedure
• INTERP Function
• INTERPCLOB Function
• GETLOG Function
• PRINTLOG Procedure