Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 30 Apr 2008 @ 11:20:05 GMT

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

Subj:   Re: Help in a procedure: Counting rows
From:   McCall, Glenn David

Have you considered using SQL to generate an appropriate SQL?

Run this:

     select 'select ''' || tablename || ''', count(*) from ' || trim (both
     from tablename) || ' union all'
     from dbc.tables
     where databasename = 'your_db' and
              tablekind = 't';

Copy and paste the output into a query tool, delete the final union all and run that. It might even run faster as it has the opportunity to do some steps in parallel.


Glenn Mc

  <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