Toad for DB2 generates wrong syntax DDL script when a table creation query UTF 8 Codeunit32 is used with clob inline.
When executed -
CREATE TABLE TEST (
ZVA VARCHAR(20 CODEUNITS32),
ZV_ZUSATZ CLOB(2000 CODEUNITS32) INLINE LENGTH 4 INLINE LENGTH 500 LOGGED NOT COMPACT
Here 'INLINE LENGTH 4' is an incorrect syntax for DB2 Database.
When the same DDL is executed Toad returns an error -
ERROR [42601] [IBM][DB2/NT64] SQL0104N An unexpected token "LENGTH 500" was found following "INE LENGTH 4 INLINE". Expected tokens may include: "<references_spec>".
Product Defect - TDB-4639
WORKAROUND
The issue occurs specifically when Codeunit32 is not used. At this time, the only available workaround is to define the CLOB without Codeunits32 or remove the invalid inline length of 4.
STATUS
Waiting for fix in a future release of Toad for DB2.
