|Oracle9i OLAP Developer's Guide to the OLAP API
Release 2 (9.2)
Part Number A95297-01
Connecting to a Data Store, 5 of 6
Some applications depend on the run-time execution of Oracle OLAP data manipulation language (DML) commands or programs. DML commands and programs execute in an analytic workspace outside the context of MDM metadata, which is intrinsic to the OLAP API. Therefore, such commands and programs do not operate on MDM objects, such as
MdmDimension. Instead, they operate on DML objects, such as variable and dimension. The MDM and DML contexts are related but distinct.
To execute DML commands or programs in an analytic workspace, create an OLAP API
SLPExecutor object, specifying the JDBC
Connection object that you want to use. Note that the data manipulation language is sometimes referred to as a stored procedure language (SPL).
The following lines of code create and initialize an
SPLExecutor object on a JDBC
Connection object called
To specify an analytic workspace in which you want to execute DML commands, attach the workspace using the DML command called
AW. For example, the following command executes the
AW command for attaching a workspace named
For information about using the DML, see the Oracle9i OLAP Developer's Guide to the OLAP DML and the Oracle9i OLAP DML Reference help. For more information about using an
SPLExecutor, see the OLAP API Javadoc.