wrap_runNonQ        (“ [OLAP DML] “)


A low level API that allows a client developer to execute Oracle OLAP DML statements directly within the Oracle OLAP environment.   wrap_runNonQ does not request any output from the Oracle OLAP environment on execution.


Because no output is requested wrap_runNonQ is often used in time sensitive operations when no output is expected as its execution time is approximately half that of calling mooExecute.



Syntax

       

               wrap_runnonq(“ [OLAP DML] “)


Return Value


               BOOLEAN


Example


Public Sub wrap_runNonQ()

'Example of wrap_runNonQ and wrap_GetDML



Dim boo As Boolean


If Not oregistered Then:   boo = regQ:


'Check Im connected if not connect

If Not o.connected Then

   boo = o.connect

   boo = o.connected

   Else

   boo = True

End If


If boo = True Then

 boo = o.wrap_runNonQ("shw tod")

   If boo = True Then

     'You Could also use .mooGetDML here

      Debug.Print (o.wrap_getDML)

   Else

      Debug.Print o.getlastmooerr

   End If

Else

   'Something went wrong print any error information

   Debug.Print "Unable to Connect"

   Debug.Print o.getlastmooerr

End If


End Sub