Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 05 Nov 2003 @ 16:53:50 GMT


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


Subj:   Re: How does queryman calculates the total number of rows?
 
From:   Dieter Noeth

  How does queryman calculates the total number of rows to display in the status bar ?? I guess we need to have another count(*) query to get such an info from teradata.  


  Is this count from queryman a guess based on random samples or what ?  



There's an ODBC function: SQLRowCount

From ODBC user guide:

"SQLRowCount returns the number of rows affected by an UPDATE, INSERT, or DELETE statement. After an SQLExecute or SQLExecDirect, SQLRowCount can be called to get the DBC Activity count for any type of SQL statement, even for SELECT statements."


Dieter



     
  <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: 15 Jun 2023