Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 19:35:44 GMT

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

Subj:   Re: Database Unspecfied?
From:   Fred W Pluebell

In answer to both this and your previous question:

When you use unqualified object names, Teradata attempts to qualify the name using the DEFAULT DATABASE in effect for the session (as one would expect) AND also using any other database explicitly included in the SQL statement. As long as there is only a single match, the resolver assumes it figured out what you meant and the statement works. If there are multiple possibilities, the statement fails.

  <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: 28 Jun 2020