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.
Thanks,
Dhiraj

Dhiraj
Tags:
Glass 225 posts Joined 04/10
16 Mar 2015

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

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.