Toad for DB2 4.6 and 4.6.2 doesn't generate the DDL correctly. Both column type LONG VARCHAR with 'FOR BIT DATA'. 1. Command db2look shown:
CREATE TABLE "WASADM "."SESSIONS" (
"ID" VARCHAR(128) NOT NULL ,
"PROPID" VARCHAR(128) NOT NULL ,
"APPNAME" VARCHAR(128) NOT NULL ,
"LISTENERCNT" SMALLINT ,
"LASTACCESS" BIGINT ,
"CREATIONTIME" BIGINT ,
"MAXINACTIVETIME" INTEGER ,
"USERNAME" VARCHAR(256) ,
"SMALL" VARCHAR(3122) FOR BIT DATA ,
"MEDIUM" LONG VARCHAR FOR BIT DATA ,
"LARGE" BLOB(2097152) LOGGED NOT COMPACT )...
2) Toad for DB2 4.6.2:
Â
CREATE TABLE "WASADM"."SESSIONS" (
"ID" VARCHAR(128) NOT NULL,
"PROPID" VARCHAR(128) NOT NULL,
"APPNAME" VARCHAR(128) NOT NULL,
"LISTENERCNT" SMALLINT,
"LASTACCESS" BIGINT,
"CREATIONTIME" BIGINT,
"MAXINACTIVETIME" INTEGER,
"USERNAME" VARCHAR(256),
"SMALL" VARCHAR(3122) FOR BIT DATA,
"MEDIUM" LONG VARCHAR, --< --- without 'FOR BIT DATA'
"LARGE" BLOB(2M) LOGGED NOT COMPACT
)...
Â