DB2 - Show create table script missing LOB length

14 views
Skip to first unread message

Hung Tam Nguyen

unread,
May 5, 2019, 12:32:31 PM5/5/19
to DB Solo
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

unread,
May 6, 2019, 5:54:33 PM5/6/19
to DB Solo
I will investigate and get back to you.

marko

DB Solo Admin

unread,
May 7, 2019, 5:11:30 PM5/7/19
to DB Solo
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
Reply all
Reply to author
Forward
0 new messages