Databases Reference
In-Depth Information
After you enter the appropriate commands to execute your database calculation
script, you can save the MaxL script by clicking
File
|
Save
and giving a name to
your file object. Just like with the
Calculation Script Editor
, the default location the
EAS saves your MaxL file to is the
Analytic Server
|
Application
|
Database
folder.
Consequently, this is where the MaxL function will look for the file when you call it.
The MaxL command script file object is saved with an
.mxl
extension.
Now that you know how to code a basic MaxL Command Script, we will describe
the various methods for executing it:
•
Through the EAS Tool
: Just like executing a calculation script from the EAS
tool, you have virtually identical options for executing a MaxL script through
the EAS tool when the MaxL script editor is open.
i) Click the menu pick
MAXL
and then click
Execute
to run the MaxL
script currently open in the editor.
ii) Click on the button on the EAS toolbar that has the small downward
pointing arrow.
iii) Press the
F5
function key on your keyboard.
•
DOS Command Line
: All you need to do is navigate to the DOS command
prompt from your desktop. The next step is to type in a typical command
line action at the command prompt. This will tell windows to run the
essmsh.exe
with the Gross Stock MaxL script:
"essmsh.exe MaxL.mxl"
•
Shell Command in Code
: You can easily use the
Shell
function in code to
run your EssCmd. The Shell function can be used in languages like Microsoft
Visual Basic or Microsoft Visual Basic for Applications to name a few.
Shell "essmsh.exe MaxL.mxl", vbNormalFocus
If you register the
essmsh.exe
on your PC, like you would register
any DLL using the
regsvr32
function, you will be able to call the
essmsh.exe
in a command line or shell command without having
to include the entire path in the command.
This is particularly useful to know because the
essmsh.exe
itself only
accepts paths with a length of upto 128 characters.
