Databases Reference
In-Depth Information
Loading data using MaxL
By now, you must be familiar with the MaxL scripting language and its statements.
We used MaxL to update the Essbase outline in the previous chapter. As you know,
there are three ways you can execute a MaxL script. First, using EAS and the MaxL
editor, second, you can execute MaxL scripts from the Command Prompt, and third,
MaxL scripts can be executed from shell commands within another program.
Let's use the EAS and the MaxL editor to create a MaxL script and then execute
the script to load data into the Essbase database.
Steps to execute MaxL from the EAS editor:
1.
Within EAS, Click on
File
|
Editor
|
MaxL Script Editor.
2.
The MaxL editor will open.
3.
Import Database MaxL statement should be used to load data.
Syntax for the Import Database MaxL statement:
IMPORT
DATABASE
APPLICATION
NAME
.
DATABASE
NAME
The various fields present in the MaxL statement are:
•
DATA
: We need to say data since we are loading data into the database.
•
CONNECT
AS
<Database
Username>
: Please specify the user name here since
we are loading the data from the relational database.
•
IDENTIFIED
BY
<Database
password>
: Specifies your database password.
•
USING
<
LOCAL
SERVER NAME>
: Location of the rules file.
•
RULES_FILE
<RULE
FILE
NAME>:
Name of the rule file like
dSales
.
•
ON
ERROR
WRITE
TO
<PATH
FOR
ERROR
FILE>
: Error file information.
The Path for error file
c:/book/dataload_chap4.err
The complete MaxL statement with correct syntax:
import database 'ESSCAR'.'ESSCAR' data
connect as 'hypuser' identified by 'password'
using server rules_file 'dSales'
on error write to c:/book/dataload_chap4.err
