Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 22 Jun 2004 @ 13:39:09 GMT

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

Subj:   Re: Is it possible to manipulate activity count?
From:   Marcus_Joseph

Just suggesting a workaround. There could be a better way to deal with this.

The following sql will always return zero rows as column DatabaseName is NOT NULL column of the underlying DBC.DBase table. If the user has access to this view, you may use it.

     Select count(*) from DBC.Databases where DatabaseName IS NULL;

  <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: 23 Jun 2019