Help tables shows truncated column names

Database
Junior Supporter

Help tables shows truncated column names

Hi,

Whan i do a help table db.tab, the column , columnname,  shows column names truncated to 30 characters. The column - column dictionary name, however shows full name. Why is this so ? i am on TD 14.10. Is this a bug ?

Thanks 

Samir

3 REPLIES
Teradata Employee

Re: Help tables shows truncated column names

Unfortunately we had to maintain compatibility for applications which were coded to use these fields in the past. So we kept the existing fields the same size as they used to be and added new fields to properly display the full names when users are taking advantage of the ability to have long object names. The same issue led to the creation of the "V" versions of the dictionary views. The V versions show the full name while the views without V still return 30 characters like they used to for compatibility. 

Junior Contributor

Re: Help tables shows truncated column names

There's no V-version of HELP, but when you scroll to the right there are some new columns, "Column SQL Name" with the full 128 Unicode characters.

I needed a few years to find this as I never looked at the full result :-)

Junior Supporter

Re: Help tables shows truncated column names

Ok, got it. Thanks Todd and Dieter !!