Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 06 Sep 2012 @ 13:06:36 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Problem with Alias in Teradata 14
From:   SUMAN M


Can someone explain how is Table & Cloumn alias resolved in Teradata 14?

Does it take reference to the table id and column id stored in system tables to resolve the alias?

There was an upgrade done from Teradata 12 to Teradata 14 recently and all the database objects were migrated from V12 to V14 along with replicating the access & user rights at database level. We are seeing problem with column alias when trying to reference from the subqueries and the joins

Scenario: If the Alias name in the main SQL is the same as those used in subquery and the joins, the query is not giving any result.

However, if the alias name in main SQL is changed to some other name, then the result works fine.

Any information related to this will be appreciated



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020