Using Toad for DB2 v 4.6.0, tried to migrate the tablespaces and dependant objects and it did not pick up the primary index. Toad for DB2 v4.5.2 is migrating the ddl correctly.
Toad for DB2 v 4.6.0 generated:
ALTER TABLE WF50PU.DM_AG_ELIG_STATUS
ADD CONSTRAINT "WFDW1RI1" PRIMARY KEY
("AG_ELIG_STAT_CD"
Â
Toad 4.5.2 generated:
CREATE UNIQUE INDEX "WF50PU"."WFDW1RI1"
ON "WF50PU"."DM_AG_ELIG_STATUS"
("AG_ELIG_STAT_CD" ASC
)
CLUSTER
PCTFREE 10
ALLOW REVERSE SCANS;
é necessário estar conectado e ter um contrato de manutenção atual para visualizar os artigos de conhecimento premium.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center