Database Reference
In-Depth Information
define label "LogFile" ;
/* Quit MaxL with a 20 error code */
exit 20 ;
/* Create label for error file errors */
define label "ErrorFile" ;
/* Quit MaxL with a 30 error code */
exit 30 ;
/* Create label for data clear error */
define label "Clear" ;
/* Quit MaxL with a 40 error code */
exit 40 ;
/* Create label for create buffer error */
define label "CreateBuffer" ;
/*
Just in case it actually got created, destroy the load buffer
*/
alter database $2.$3 destroy load_buffer with buffer_id 1 ;
/* Quit MaxL with a 50 error code */
exit 50 ;
/* Create label for data load to buffer error */
define label "DataLoadToBuffer" ;
/*
Just in case it actually got created, destroy the load buffer
*/
alter database $2.$3 destroy load_buffer with buffer_id 1 ;
/* Quit MaxL with a 60 error code */
exit 60 ;
/* Create label for load from buffer error */
define label "LoadFromBuffer" ;
/*
Just in case it actually got created, destroy the load buffer
*/
alter database $2.$3 destroy load_buffer with buffer_id 1 ;
/* Quit MaxL with a 70 error code */
exit 70 ;
2.6.2.2.3 Validate.msh
OS_MaxLReportRun Command line
cmd /c C:\Oracle\Middleware\EPMSystem11R1\products\Essbase\
EssbaseClient\bin\startMaxl.cmd c:\tempdir\MaxL\scripts\#VAR_
MaxLScriptName.msh #VAR_MaxLScriptName #VAR_AppName #VAR_DbName
#VAR_MaxLReportName
Purpose—
run the report Script validate.rep to a local text file. This upper-level data
will be pulled into SQL via oDI and compared to a relationally summed table.
Code
/*
Purpose:
Export current top level data for validation
Written by: Cameron Lackpour
Modified:
11 November 2011, initial write
Notes:
Parameter variables:
-- $1 = Script name
-- $2 = Application name
