Archives of the TeradataForum

Message Posted: Mon, 17 Dec 2001 @ 17:20:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Paul,

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;

bteq myscript.out

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.

Cheers,

Dave

	<Prev	Next>		<<First	<Prev	Next>	Last>>