Total Pageviews

Sunday, 17 November 2013

Sample BTEQ Export

exec 1> logfileName.log 2>&1
bteq <<EOF
.SET WIDTH 200;
.SET SESSION TRANSACTION BTET;
.run file LoginFile;
database DB_Name;
.SET WIDTH 500;
.SET TITLEDASHES OFF ;
.EXPORT REPORT FILE=/$PATH/FileName.txt
SQL Query;
.EXPORT RESET;

.QUIT 0
EOF