Programming Language Changes

Numerous changes have been made to the Express Stored Procedure Language (now called the OLAP Data Manipulation Language or OLAP DML).

New Commands

Support in the following areas has been added to the OLAP DML:

• Parallel aggregate
• Allocation
• Dynamic model execution
• Bulk data transfers between analytic workspaces and relational tables
• Byte manipulation functions
• Data conversion functions
• New data types

Obsolete Commands

Support in the following areas has been dropped:

• EXTCALL
• ODBC
• SNAPI
• XCA
• Operating system commands

For comprehensive lists of new, obsolete, and significantly revised commands, open OLAP DML Help and click List of Changes on the Contents page.

UPDATE and COMMIT

The UPDATE command moves analytic workspace changes from a temporary area to the database table in which the workspace is stored. Your changes are not saved until you execute a COMMIT command, either from your Oracle OLAP session or from SQL.

If you want changes that you have made in a workspace to be committed when you execute the COMMIT command, then you must first update the workspace using the UPDATE command. Changes that have not been moved to the table are not committed.

The COMMIT command executes a SQL COMMIT command. All changes made during your session are committed, whether they were made through Oracle OLAP or through another form of access (such as SQL) to the database.