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
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