Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Returning ONLY the data portion of a SELECT via BTEQ inSTDOUT
From:   Al MacGowan

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;

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

Alistair MacGowan
Senior Database Administrator

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020