Venkat Muthuswamy created TRAFODION-1793: --------------------------------------------
Summary: GET commands that report usage information should return 3 or 2 part ansi object names Key: TRAFODION-1793 URL: https://issues.apache.org/jira/browse/TRAFODION-1793 Project: Apache Trafodion Issue Type: Bug Reporter: Venkat Muthuswamy Let's see we create a view that joins 2 tables from different schemas. CREATE VIEW TRAFODION.SCH.V1 AS SELECT 1 AS Z FROM TRAFODION.SCH.T, TRAFODION.SEABASE.T ; Now if we try to get the tables used by V1 using this command, it just returns the object names and it is difficult to say which object is which since the schema information is missing. get tables in view v1; It returns : >>get tables in view v1; Tables in View SCH.V1 ===================== T T It would be good if the GET commands can return the 3 or 2 part ansi name of the object. -- This message was sent by Atlassian JIRA (v6.3.4#6332)