Home Page for the TeradataForum
 

Archives of the TeradataForum

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


     
  <Prev Next>  
<<First
<Prev
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;
     .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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016