how-to use bteq with windows cmd

START ===== C:\Temp\PROC\SQL\tera\btq\all.txt

START ===== C:\Temp\PROC\SQL\tera\btq\all.txt
END ================== C:\Temp\PROC\SQL\tera\btq\all.txt
START ===== C:\Temp\PROC\SQL\tera\btq\BteqMultiStarter.cmd
@echo off
for /f "tokens=*" %%i in ( ' DIR *.btq /b ') do start /min cmd /c bteq < %%i > %%i_output.txt
pause
::bteq < test.btq > output.txtEND ================== C:\Temp\PROC\SQL\tera\btq\BteqMultiStarter.cmd
START ===== C:\Temp\PROC\SQL\tera\btq\BtqStarter.cmd
bteq < test.btq > output.txt 2>error.log
start /min output.txt
start /min error.logEND ================== C:\Temp\PROC\SQL\tera\btq\BtqStarter.cmd
START ===== C:\Temp\PROC\SQL\tera\btq\ConcatenateAll.cmd
echo empty the file

echo. >all.txt

echo for each log file in the current directory do contcatenate it
echo in the all.txt file
for /f %%i in ('dir /s /b /a-d') do echo START ===== %%i>>all.txt&type %%i>>all.txt&echo END ================== %%i>>all.txt

echo open the all.txt file
all.txtEND ================== C:\Temp\PROC\SQL\tera\btq\ConcatenateAll.cmd
START ===== C:\Temp\PROC\SQL\tera\btq\test.btq
.LOGON td/dbName,pass;

* THIS IS COMMENT
* .show version
.SET ERROROUT STDERR

.EXPORT DATA FILENAME='data.txt'

SELECT TOP 100 * FROM dbName .T_Table ;


.QUIT
END ================== C:\Temp\PROC\SQL\tera\btq\test.btq