Voltar
-
Título
'FOR BIT DATA' attribute is not generated correctly in Toad for DB2 4.6 -
Descrição
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
)...
Â
Login necessário
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.