Hi Team,
In TD 14 we are allowed to create tables with names more than 30 characters, but in dbc.tables the length for tablename is still 30, so if we give a tablename like dbname.sample_table_in_teradata_fourteen , then in dbc.tables we need to search with tablename = 'sample_table_in_teradata_fourt' .
I guess this needs to be fixed in order to retrieve correct table name from dbc table.
Don't use DBC.Tables.
Use DBC.TablesV.
Recommend that you use the 'V' views as standard.
Cheers,
Dave
Thanks for the info. :)
But any specific reason to use tablesv , apart from the column names .The FROM clause in both views are same.
The non-V views are deprecated, meaning they are outdated and obsolete. They continue to be provided for legacy scripts and applications, but you should stop using the non-V views as soon as you can, and switch over to using the V views.
Any new scripts and applications should use the V views. As new features are added to the Teradata Database, new columns will be added to the V views.
All the object names (database, table, column, UDT type names, etc.) are truncated in the non-V views.
and, you will find that the V views are more performant, faster.
dave
Thanks for the information !!