Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Aug 2015 @ 19:53:13 GMT


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


Subj:   Re: List of tables not accessed in 6 months
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, August 14, 2015 14:05 -->

Use DBC.TablesV (which is already VARCHAR so no need to cast) - the old pre-TD12 compatibility views like Tables should be avoided in new SQL.

You say results are wrong. Can you be more specific about what the problem is?



     
  <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