Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 18 Nov 2009 @ 10:03:47 GMT


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


Subj:   Re: Views not showing result from table
 
From:   Barrineau, Claybourne

Anomy,

When you execute the SQL against the 4 views, are you qualifying the database names? It is possible that unqualified view references are defaulting to your 'default database' as opposed to the view (which would default any unqualified views with the default database associated with the user that created the view.)

It would help to see the SQL and view DDL.


Thanks,

Clay



     
  <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