Toad World® Forums

Compare issue


#1

The field REFERENCE_ID seems to be highlighted unnecessarily, note the side view
doesn’t show it as different.

Source Script

CREATE TABLE “FDBMD”.“CLAIM_MASTER” (

“CLAIM_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0, INCREMENT BY 1, CACHE 20,

MINVALUE -2147483648, NO MAXVALUE, CYCLE, NO ORDER),

“FAMILY_ID” INTEGER NOT NULL,

“RELATION_ID” SMALLINT NOT NULL,

“PART_SSN” INTEGER NOT NULL,

“PAT_SSN” INTEGER NOT NULL,

“PRIORITY” INTEGER NOT NULL,

“SECURITY_SW” DECIMAL(1,0) NOT NULL,

“ATTACH_SW” DECIMAL(1,0) NOT NULL,

“DUPLICATE_SW” DECIMAL(1,0) NOT NULL,

“BUSY_SW” DECIMAL(1,0) NOT NULL,

“ARCHIVE_SW” DECIMAL(1,0) NOT NULL,

“STATUS” VARCHAR(20) FOR SBCS DATA NOT NULL,

“STATUS_DATE” TIMESTAMP NOT NULL,

“DOC_CLASS” VARCHAR(32) FOR SBCS DATA NOT NULL,

“DOC_TYPE” VARCHAR(64) FOR SBCS DATA NOT NULL,

“DOCID” DECIMAL(18,0) WITH DEFAULT NULL,

“MAXID” VARCHAR(26) FOR SBCS DATA WITH DEFAULT NULL,

“BATCH” VARCHAR(24) FOR SBCS DATA WITH DEFAULT NULL,

“REC_DATE” DATE WITH DEFAULT NULL,

“OPEN_DATE” TIMESTAMP WITH DEFAULT NULL,

“PROCESSED_DATE” TIMESTAMP WITH DEFAULT NULL,

“DATE_OF_SERVICE” DATE WITH DEFAULT NULL,

“PAGE_COUNT” INTEGER WITH DEFAULT NULL,

“PENDED_TO” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PENDED_DATE” TIMESTAMP WITH DEFAULT NULL,

“AUDITED_BY” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“AUDIT_DATE” TIMESTAMP WITH DEFAULT NULL,

“ROUTED_BY” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“ROUTED_DATE” TIMESTAMP WITH DEFAULT NULL,

“PAT_FNAME” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PAT_INT” VARCHAR(1) FOR SBCS DATA WITH DEFAULT NULL,

“PAT_LNAME” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PART_FNAME” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PART_INT” VARCHAR(1) FOR SBCS DATA WITH DEFAULT NULL,

“PART_LNAME” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PROV_TIN” INTEGER WITH DEFAULT NULL,

“PROV_ID” INTEGER WITH DEFAULT NULL,

“REFRENCE_CLAIM” INTEGER WITH DEFAULT NULL,

“CREATE_USERID” VARCHAR(40) FOR SBCS DATA NOT NULL,

“CREATE_DATE” TIMESTAMP NOT NULL,

“USERID” VARCHAR(40) FOR SBCS DATA NOT NULL,

“LASTUPDT” TIMESTAMP NOT NULL,

“PARTITION_DD” SMALLINT DEFAULT 31,

“LOCAL_SW” DECIMAL(1,0) DEFAULT 0,

“PROCESSED_BY” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“LAST_ACCESSED_ DATE” TIMESTAMP WITH DEFAULT NULL,

“LAST_ACCESSED_ BY” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“EDI_STATUS_DATE” TIMESTAMP WITH DEFAULT NULL,

“EDI_STATUS” VARCHAR(12) FOR SBCS DATA WITH DEFAULT NULL,

“EDI_SOURCE” VARCHAR(50) FOR SBCS DATA WITH DEFAULT NULL,

“SCAN_DATE” TIMESTAMP WITH DEFAULT NULL,

“REFERENCE_ID” VARCHAR(30) FOR SBCS DATA WITH DEFAULT NULL ,

CONSTRAINT “CLAIM_ID” PRIMARY KEY

(“CLAIM_ID”)

) PARTITION BY RANGE ( “PARTITION_DD” ) (

PARTITION 1 ENDING AT (3),

PARTITION 2 ENDING AT (6),

PARTITION 3 ENDING AT (7),

PARTITION 4 ENDING AT (12),

PARTITION 5 ENDING AT (16),

PARTITION 6 ENDING AT (20),

PARTITION 7 ENDING AT (24),

PARTITION 8 ENDING AT (28),

PARTITION 9 ENDING AT (31) )

IN “FDBMD”.“FTSCLMPD”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC;

ALTER TABLE “FDBMD”.“CLAIM_MASTER”

ADD CONSTRAINT “FK_CLAIM_MST_ TO_STAAUS_ VALUES” FOREIGN KEY

(“STATUS”)

REFERENCES “FDBMD”.“CLAIM_STATUS_ VALUES”

(“STATUS”)

ON DELETE RESTRICT

ENFORCED;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT ON TABLE “FDBMD”.“CLAIM_MASTER” TO “PFDBREAD”;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE “FDBMD”.“CLAIM_MASTER” TO
“TFDBUPDT”;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT ON TABLE “FDBMD”.“CLAIM_MASTER” TO “TFDBREAD”;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE “FDBMD”.“CLAIM_MASTER” TO
“PFDBUPDT”;

Target script

CREATE TABLE “FDBMD”.“CLAIM_MASTER” (

“CLAIM_ID” INTEGER NOT NULL GENERATED BY DEFAULT

AS IDENTITY (START WITH 0, INCREMENT BY 1, CACHE 20,

MINVALUE -2147483648, NO MAXVALUE, CYCLE, NO ORDER),

“FAMILY_ID” INTEGER NOT NULL,

“RELATION_ID” SMALLINT NOT NULL,

“PART_SSN” INTEGER NOT NULL,

“PAT_SSN” INTEGER NOT NULL,

“PRIORITY” INTEGER NOT NULL,

“SECURITY_SW” DECIMAL(1,0) NOT NULL,

“ATTACH_SW” DECIMAL(1,0) NOT NULL,

“DUPLICATE_SW” DECIMAL(1,0) NOT NULL,

“BUSY_SW” DECIMAL(1,0) NOT NULL,

“ARCHIVE_SW” DECIMAL(1,0) NOT NULL,

“STATUS” VARCHAR(20) FOR SBCS DATA NOT NULL,

“STATUS_DATE” TIMESTAMP NOT NULL,

“DOC_CLASS” VARCHAR(32) FOR SBCS DATA NOT NULL,

“DOC_TYPE” VARCHAR(64) FOR SBCS DATA NOT NULL,

“DOCID” DECIMAL(18,0) WITH DEFAULT NULL,

“MAXID” VARCHAR(26) FOR SBCS DATA WITH DEFAULT NULL,

“BATCH” VARCHAR(24) FOR SBCS DATA WITH DEFAULT NULL,

“REC_DATE” DATE WITH DEFAULT NULL,

“OPEN_DATE” TIMESTAMP WITH DEFAULT NULL,

“PROCESSED_DATE” TIMESTAMP WITH DEFAULT NULL,

“DATE_OF_SERVICE” DATE WITH DEFAULT NULL,

“PAGE_COUNT” INTEGER WITH DEFAULT NULL,

“PENDED_TO” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PENDED_DATE” TIMESTAMP WITH DEFAULT NULL,

“AUDITED_BY” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“AUDIT_DATE” TIMESTAMP WITH DEFAULT NULL,

“ROUTED_BY” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“ROUTED_DATE” TIMESTAMP WITH DEFAULT NULL,

“PAT_FNAME” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PAT_INT” VARCHAR(1) FOR SBCS DATA WITH DEFAULT NULL,

“PAT_LNAME” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PART_FNAME” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PART_INT” VARCHAR(1) FOR SBCS DATA WITH DEFAULT NULL,

“PART_LNAME” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“PROV_TIN” INTEGER WITH DEFAULT NULL,

“PROV_ID” INTEGER WITH DEFAULT NULL,

“REFRENCE_CLAIM” INTEGER WITH DEFAULT NULL,

“CREATE_USERID” VARCHAR(40) FOR SBCS DATA NOT NULL,

“CREATE_DATE” TIMESTAMP NOT NULL,

“USERID” VARCHAR(40) FOR SBCS DATA NOT NULL,

“LASTUPDT” TIMESTAMP NOT NULL,

“LOCAL_SW” DECIMAL(1,0) NOT NULL DEFAULT 0,

“PROCESSED_BY” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“LAST_ACCESSED_ DATE” TIMESTAMP WITH DEFAULT NULL,

“LAST_ACCESSED_ BY” VARCHAR(40) FOR SBCS DATA WITH DEFAULT NULL,

“EDI_STATUS_DATE” TIMESTAMP WITH DEFAULT NULL,

“EDI_STATUS” VARCHAR(12) FOR SBCS DATA WITH DEFAULT NULL,

“EDI_SOURCE” VARCHAR(50) FOR SBCS DATA WITH DEFAULT NULL,

“SCAN_DATE” TIMESTAMP WITH DEFAULT NULL,

“REFERENCE_ID” VARCHAR(30) FOR SBCS DATA WITH DEFAULT NULL

,

CONSTRAINT “CLAIM_ID” PRIMARY KEY

(“CLAIM_ID”)

) PARTITION BY RANGE ( “CLAIM_ID” ) (

PARTITION 1 ENDING AT (1000000),

PARTITION 2 ENDING AT (2000000),

PARTITION 3 ENDING AT (3000000),

PARTITION 4 ENDING AT (4000000),

PARTITION 5 ENDING AT (5000000),

PARTITION 6 ENDING AT (6000000),

PARTITION 7 ENDING AT (7000000),

PARTITION 8 ENDING AT (8000000),

PARTITION 9 ENDING AT (9000000) )

IN “FDBMD”.“FTSCLMST”

AUDIT NONE

DATA CAPTURE NONE

NOT VOLATILE

APPEND NO

CCSID EBCDIC;

ALTER TABLE “FDBMD”.“CLAIM_MASTER”

ADD CONSTRAINT “FK_CLAIM_MST_ TO_STATUS_ VALUES” FOREIGN KEY

(“STATUS”)

REFERENCES “FDBMD”.“CLAIM_STATUS_ VALUES”

(“STATUS”)

ON DELETE RESTRICT

ENFORCED;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT ON TABLE “FDBMD”.“CLAIM_MASTER” TO “PFDBREAD”;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT ON TABLE “FDBMD”.“CLAIM_MASTER” TO “TFDBUPDT”;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT ON TABLE “FDBMD”.“CLAIM_MASTER” TO “TFDBREAD”;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT, INSERT, UPDATE, DELETE ON TABLE “FDBMD”.“CLAIM_MASTER” TO
“PFDBUPDT”;

SET SCHEMA = ‘CONFIG’;

SET CURRENT SQLID = ‘CONFIG’;

GRANT SELECT ON TABLE “FDBMD”.“CLAIM_MASTER” TO “PATM”;

SET SCHEMA = ‘PFBATCH’;

SET CURRENT SQLID = ‘PFBATCH’;

GRANT SELECT ON TABLE “FDBMD”.“CLAIM_MASTER” TO “PATM”;

image001.jpeg


#2

Hi Mark,

The red “missing” color does seem incorrect. I opened CR 70,668 to
track this issue.

Thanks,

Adam
image001.jpeg