When a MaxL statement is passed to Essbase Server interactively or in batch mode via the MaxL Shell (essmsh), it must be terminated by a semicolon. Semicolons are used only to tell essmsh when to terminate the statement; semicolons are not part of the MaxL language itself. Therefore, when issuing MaxL statements programmatically through Perl or API programs, do not use semicolons.
Program | Example |
---|---|
Interactive MaxL Shell | create application Sample; |
MaxL Shell script: | login $1 identified by $2; create application Sample; create currency database Sample.Interntl; display database Sample.Interntl; exit; |
Perl function (Correct) | print $dbh->do("create currency database Sample.Interntl"); |
Perl function (Incorrect) | print $dbh->do("create currency database Sample.Interntl;"); |