The following is the template I am using... but I do not have a statement that handles MaxErrorLevel. But I am having retention limit, page lenght and width setup etc.,


#**************************************************
# Script Name : XXXXXXX.SQL *
# Created Date : XX/XX/XX *
# Purpose : *
# Change Log : *
# Shastry S S XX/XX/XX XXXXXXXXXXXXXXXXXXX *
#**************************************************

v1=$1

bteq <.run file /u/u773595/logon.sql
.echoreq on;
.pagelength 5000;
.null '~';
.set width 254;
.set retlimit 10;
.set retcancel on;

database ${v1};

--$v1 = XXXXXX
--$v2 = XXXXXX

select date, time;



select date, time;

.logoff;
.quit;

EOF


Hope it is what you are expecting.