Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 18:05:53 GMT


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


Subj:   Help me understand..
 
From:   Arunachalam, Sankar

Folks,

Test (1) Environment:

database: dev1
Tables: tab1, tab2


Test (2) Environment:

Database: dev2
Tables: tab1, tab2


Both databases on the same Teradata System having identical table structures, names, access rights etc.,

I have a query like this

select col1, col2, col3....
from dev1.tab1, tab2
where inner-join conditions...


Below are the different scenarios:

1: when the default database is 'dev2' This gives me a Table/View/Macro name 'tab2' is ambiguous error

2: When the default database is 'dev1' -- works fine

3. When the default database is either 'dev2' or 'dev1' without the 'dev1' qualifier on 'tab1' works fine..

4: When the default database is either 'dev1' or 'dev2' with both the tables properly qualified as dev1.tab1 and dev2.tab2


Is this a bug? or Am I missing a link? Does anyone see what is wrong with this?

Thanks

Sankar



     
  <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