Archives of the TeradataForum
Message Posted: Mon, 17 Dec 2001 @ 17:20:44 GMT
I think you'll find that it's not BteqWin that you want but the DOS version of Bteq.
When you install the Teradata Client, the bin directory contains the executables including BteqWin.exe and Bteq.exe. This last one is the DOS version.
This will take a script file as input and write it's output to another file (i.e. a log file). I've used this approach quite a lot. To run it via the Windows task scheduler the actual command line for bteq is something like;
This will read in the "myscript.txt" file and write the output to "myscript.out" (the equivalent of sysprint in MVS.
One word of caution, in your bteq scripts, make sure you use the command ".set errorout stdout" to force DBMS error messages to be written to your log file (myscript.out in the above example). Otherwise they get written to the dos window and then get lost when that window closes at the end of the script.
If you need anything else just ask.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|