When generating the script after altering a table by adding several columns - the order of the columns is not the order in which they were added....they are lister alphabetically.....
Sample output - 4.7 (which is fine) vs 5.0.2
Toad 4.7:
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "MKS_BD_ENTRPS_ID" CHARACTER(11);
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "RIS_MKTR_ORG_CHNL_CD" SMALLINT;
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "PRMY_CHNL_TXT" CHARACTER(30);
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "PRMY_BUSN_MODL_CD" SMALLINT;
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "PFRD_EMAIL_ID" INTEGER;
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "PFRD_PH_ID" INTEGER;
REORG TABLE "DB2OD"."O_PN_FP";
Toad 5.0:
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "MKS_BD_ENTRPS_ID" CHARACTER(11);
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "PFRD_EMAIL_ID" INTEGER;
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "PFRD_PH_ID" INTEGER;
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "PRMY_BUSN_MODL_CD" SMALLINT;
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "PRMY_CHNL_TXT" CHARACTER(30);
ALTER TABLE "DB2OD"."O_PN_FP"
ADD COLUMN "RIS_MKTR_ORG_CHNL_CD" SMALLINT;
REORG TABLE "DB2OD"."O_PN_FP";
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center