Looking for BTEQ Templates

Tools & Utilities
Enthusiast

Looking for BTEQ Templates

I'm looking for a template to use for generating BTEQ scripts.

Something that already has the standard audit info at the top (name, author, date, purpose, etc) and some standard options that need to be set (MaxErrorLevel, etc).

I thought there would be something in Atanasuite like their is in Toad for Oracle, but I couldn't find anything. So I'm looking to the forums to see if anyone has something they would be wiling to share.

Thanks,

James.
1 REPLY
Enthusiast

Re: Looking for BTEQ Templates

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.