Databases Reference
In-Depth Information
Steps to Execute MaxL from the EAS Editor:
1. Within EAS, click on
File
|
Editor
|
MaxL Script Editor.
2. The MaxL editor will be opened.
3. Variables can be defined at the Server, Database, and Application level.
Create variables at the server level
Server level variables can be created by the use of
ALTER
statement.
Syntax:
ALTER SYSTEM ADD/SET/DROP VARIABLE
•
VARIABLE-NAME
: Name of the variable
•
STRING
: Value for the variable
Example:
• Create Variable:
alter system add variable 'varSystem' '200801';
• Edit Variable:
alter system set variable 'varSystem' '200802';
• Delete Variable:
alter system drop variable 'varSystem';
Create variables at the application level
Using the
ALTER
command at the application level, we can create, edit, or delete
a substitution variable.
Syntax
:
ALTER APPLICATION [APPLICATION-NAME] ADD/SET/DROP VARIABLE
•
VARIABLE-NAME
: Name of the variable
•
STRING
: Value for the variable
Example
:
• Create Variable:
alter application ESSCAR add variable 'varAppl'
'ESSCAR1';
• Edit Variable:
alter application ESSCAR set variable 'varAppl'
'ESSCAR';
• Delete Variable:
alter application ESSCAR drop variable 'varAppl';