Archives of the TeradataForum

Message Posted: Thu, 01 Sep 2005 @ 19:16:24 GMT

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

I'm having a heck of a time with BTEQ. Perhaps my usage isn't possible?!

I want to execute the following "logic".. And I want to have come back to me only "1" in STDOUT, just the number returned from the SELECT.

     .logon myserv/myuser,mypass
     select count(*) from mytable;
     .quit

I've tried handfuls of different settings, including outputting to a file, but cannot get away from, at a minimum, the column heading, along with a set of dashes underneath the column heading.

Does anyone have any suggestions for me please? Thanks! I'm on Windows 2003. BTEQ 8.02.02.00

Alistair MacGowan
Senior Database Administrator

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