A lot of the entities and attributes of our logical data model have long descriptions.
After transforming into a physical model and generating the DDL we have the problem, that we can not execute the DDL on DB2 (Unix), because the comments on attributes are too long.
We need the comments on the database, so we don't like to delete them at all. But we would expect a functionality in IDA, that cuts the comment during the transform to phy. data model or during DDL generation. Is there such a function, we could not find? Do you have any recommendations?
we are working with IDA 22.214.171.124.
Thank you in advance!
This topic has been locked.
1 reply Latest Post - 2012-04-20T15:53:49Z by null
Pinned topic Cut the Documentation / COMMENT ON 254
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-04-20T15:53:49Z at 2012-04-20T15:53:49Z by null
null 0600011FWD59 PostsACCEPTED ANSWER
Re: Cut the Documentation / COMMENT ON 2542012-04-20T15:53:49Z in response to SystemAdminIDA do not truncate comments. The reasons are:
1. It will lost data
2. User may not realized the comments get cut
So if DDL deploy failed, user need go back to model to make the correction.