When reverse engineering a DDL script (DB2 11.1) the given table properties are correctly taken into the entity settings, (the "table space" and the "organize by"), but they are additionally written into the free-text field, on tab "Table Properties".
When looking at the generated SQL Preview, those clauses are doubled and cause an error when trying to execute the ddl command.
WORKAROUND
use the following order of commands:
IN "STAGING"
ORGANIZE BY ROW
COMPRESS YES ADAPTIVE
instead of the original:
COMPRESS YES ADAPTIVE
IN STAGING
ORGANIZE BY ROW;
SOLUTION:
Waiting for a fix in a future version of Toad Data Modeler.
© ALL RIGHTS RESERVED. Feedback Termini di utilizzo Privacy Cookie Preference Center