All Forums Data Modeling
dhirajpalse 36 posts Joined 01/08
11 Mar 2015
Max column length in ERWin for Teradata 14.10 columns

I have ERWin v9.5 std edition and working with Teradata DB v14.10.
This DB version allows the column length to be 128 characters.
I am trying to reverse engineer a Teradata table in ERWin where columns' length is ranging between 70 to 80 characters. But column names are trimmed  to 30 chars only while doing so. I can't increase the column length in 'Model Naming Options' as it clearly says 'Max length of column cannot exceed 30'.
Is there a patch available for ERWin to address this gap between DB column length limit and tool column length limit? OR i am missing any other options?
Appreciate your help on this.

Glass 225 posts Joined 04/10
16 Mar 2015

Erwin 9.5 has support for TD 13 so for patch questions I'd suggest posting on the CA website, or contact CA support.

AndrewSchroter 14 posts Joined 11/06
22 Oct 2015

ERWIN 9.6.1 supports 128 character object names 64 in Latin 128 for UNICODE, a 2-byte character set)

You must sign in to leave a comment.