DBC VIEWs trim to length 30 on Teradata 14

Database

DBC VIEWs trim to length 30 on Teradata 14

I do not understand why the VIEWS found in DBC are trimming DatabaseName, TableName and ColumnName to length 30 when Teradata 14 are capable of handling object names up to 127?

Br

Peter Schwennesen

3 REPLIES

Re: DBC VIEWs trim to length 30 on Teradata 14

I think this discussion can help you:

http://forums.teradata.com/forum/database/dbc-tables-has-truncated-view-defination-in-requesttext-fi...

When you do show select * from dbc.tables, you can see how it is built-up.

N/A

Re: DBC VIEWs trim to length 30 on Teradata 14

Hi Peter,

you have to use the V versions of the views from 14 onwards

like dbc.tablesV

these will show the full names...

From the manuals:

"Because data dictionary tables can change, views provide greater stability.

Modern views all end with a suffix “V” or “VX” (for example, All_RI_ChildrenV or All_RI_ChildrenVX) and return extended object names without any conversion to standard language support systems (Latin) or Japanese language support systems (Kanji1) character type.

Note: Most modern views return columns with Unicode data types, but there are some that do not (for example, DBC.RCC_ConfigurationV and DBC.RCC_MediaV are examples of modern views that do not return Unicode columns)."

Could mean some changes to different maintenance and analytic scripts...

Ulrich

Re: DBC VIEWs trim to length 30 on Teradata 14

ok.

Thansk

Peter Schwennesen