Executing DML Commands Through the Connection

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 MdmMeasure and 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 conn.

Example 3-6 Executing DML Commands

SPLExecutor dmlExec = new SPLExecutor(conn);
dmlExec.initialize();

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 mysales.

string returnVal = dmlExec.execute('aw attach mysales');

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.