Previous
Previous
 
Next
Next

Exporting Data from OLAP DML Objects to Relational Tables

Within a program, you can use an OLAP DML SQL statement with the INSERT keyword to copy data from analytic workspace objects into relational tables. Typically, you do this by issuing the following statements in your OLAP DML program:

  1. SQL PREPARE statements, to precompile the INSERT and UPDATE statements.

  2. SQL EXECUTE statements, to execute the statements that you precompiled in Step 1.