DB2 - Show create table script missing LOB length

[Hung Tam Nguyen]

WIth DB2 at least, DBSolo does not take into account the custom length of any BLOB or CLOB columns, it always create a script without specifying any length for those columns (which DB2 then defaults to 1M).

To reproduce

1 - Create an empty table

CREATE TABLE LOB_TEST (ID      INTEGER NOT NULL,

                              ATTACHMENT     BLOB(2M),

)

2- Right-click the table above, choose "Show CREATE TABLE script"

3- Notice how the generated script does not specify the expected length of 2M

[DB Solo Admin]

I will investigate and get back to you.

marko

[DB Solo Admin]

This should be fixed now. You can find the fixed version at dbsolo.com/preview

Let me know if it does not work correctly.

Marko