Databases Reference
In-Depth Information
Setting variables at the System level
alter system set variable <variable-Name> <variable-value>;
Code Samples:
alter application 'ESSCAR' set variable 'sCurrMonth' '200902';
alter database 'ESSCAR'. 'ESSCAR' set variable 'sCurrMonth'
'200902';
alter system set variable 'sCurrMonth' '200902';
•
drop variable
: This command is used to delete an existing
Substitution Variable
.
Syntax:
Drop a substitution variable at the Application level
alter application <App-Name> drop variable <variable-Name>;
Drop a substitution variable at the Database level
alter database <App-Name>.<db-name> drop variable
<variable-Name>;
Drop a substitution variable at the System level
alter system drop variable <variable-Name>;
Code Samples:
alter application 'ESSCAR' drop variable 'sCurrMonth';
alter database 'ESSCAR'. 'ESSCAR' drop variable 'sCurrMonth';
alter system drop variable 'sCurrMonth';
Executing a MaxL statement
Now that you have learned how powerful the MaxL statements are, let's see how
we can execute the statements. The MaxL statements can be written in any text
editor like Windows Notepad and you then save the file with the
.mxl
extension.
How do we run a MaxL statement? There are a couple of ways this can
be accomplished. They are as follows:
• Run MaxL from the command prompt using the MaxL shell
• Executing a MaxL statement from the MaxL editor in EAS
