All Forums Database
teradatauser2 236 posts Joined 04/12
19 May 2016
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

ToddAWalter 316 posts Joined 10/11
19 May 2016

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. 

dnoeth 4628 posts Joined 11/04
20 May 2016

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 :-)

Dieter

teradatauser2 236 posts Joined 04/12
20 May 2016

Ok, got it. Thanks Todd and Dieter !!

You must sign in to leave a comment.