Maxl Script for Substitution variable

Using Maxl script we can create substitution variable.

Script to create Substitution variable

*****************************************************************

spool on to 'C:\\batch\subvar.log';
login 'admin' 'password' on 'sales';

alter database 'sales2'.'sales2' drop variable curmon;
alter database 'sales2'.sales2' add variable 'curmon' 'jan2009';
logout;
exit;

*****************************************************************

If the variable is not there it just giving the error and rest of the

part will get executed. Save the file as subvar.mxl and create a batch file

and edit this.

ESSMCH C:\\batch\subvar.mxl '"jan2009"' '"june2009"'