--Start of generated script for 10.136.1.5-DB2-LIS (db2inst1)--Apr-10-2017 at 16:35:18
CREATE TABLE"DB2INST1"."LLCASE"
("CASENO"VARCHAR(20) NOT NULL,
"RGTNO"VARCHAR(20),
"RGTTYPE"VARCHAR(1) NOT NULL,
"RGTSTATE"VARCHAR(2) NOT NULL,
"CUSTOMERNO"VARCHAR(24) NOT NULL,
"CUSTOMERNAME"VARCHAR(120),
"ACCIDENTTYPE"VARCHAR(1),
"RECEIPTFLAG"VARCHAR(1),
"HOSPITALFLAG"VARCHAR(1),
"SURVEYFLAG"VARCHAR(1),
"RGTDATE" DATE,
"HANDLEDATE" DATE,
"CLAIMCALDATE" DATE,
"AFFIXGETDATE" DATE,
"FEEINPUTFLAG"VARCHAR(1),
"INHOSPITALDATE" DATE,
"OUTHOSPITALDATE" DATE,
"INVALIHOSDAYS"SMALLINT,
"INHOSPITALDAYS"SMALLINT,
"DIANOSEDATE" DATE,
"POSTALADDRESS"VARCHAR(300),
"PHONE"VARCHAR(20),
"ACCSTARTDATE" DATE,
"ACCIDENTDATE" DATE,
"ACCIDENTSITE"VARCHAR(60),
"DEATHDATE" DATE,
"CUSTSTATE"VARCHAR(2),
"ACCDENTDESC"VARCHAR(6000),
"CUSTBIRTHDAY" DATE,
"CUSTOMERSEX"VARCHAR(1),
"CUSTOMERAGE"DECIMAL(5, 0),
"IDTYPE"VARCHAR(1),
"IDNO"VARCHAR(20),
"HANDLER"VARCHAR(10),
"UWSTATE"VARCHAR(10),
"DEALER"VARCHAR(10),
"APPEALFLAG"VARCHAR(1),
"TOGETHERGET"VARCHAR(1),
"GRPDEALFLAG"VARCHAR(1),
"GETMODE"VARCHAR(2),
"GETINTV"SMALLINT,
"CALFLAG"VARCHAR(1),
"UWFLAG"VARCHAR(1),
"DECLINEFLAG"VARCHAR(1),
"ENDCASEFLAG"VARCHAR(1),
"ENDCASEDATE" DATE,
"MNGCOM"VARCHAR(10) NOT NULL,
"OPERATOR"VARCHAR(10) NOT NULL,
"MAKEDATE" DATENOT NULL,
"MAKETIME"VARCHAR(8) NOT NULL,
"MODIFYDATE" DATENOT NULL,
"MODIFYTIME"VARCHAR(8) NOT NULL,
"BANKCODE"VARCHAR(10),
"BANKACCNO"VARCHAR(40),
"ACCNAME"VARCHAR(120),
"CASEGETMODE"VARCHAR(2),
"ACCMODIFYREASON"VARCHAR(400),
"CASENODATE" DATE,
"CASEPROP"CHARACTER(2),
"REMARK"VARCHAR(2000),
"CANCLEREASON"CHARACTER(2),
"CANCLEREMARK"VARCHAR(500),
"CANCLER"CHARACTER(10),
"CANCLEDATE" DATE,
"RIGISTER"CHARACTER(10),
"CLAIMER"CHARACTER(10),
"UWER"CHARACTER(10),
"UWDATE" DATE,
"SIGNER"CHARACTER(10),
"SIGNERDATE" DATE,
"RISKCODE"VARCHAR(10),
"OTHERIDTYPE"VARCHAR(2),
"OTHERIDNO"VARCHAR(50),
"GRPNO"VARCHAR(20),
"GRPNAME"VARCHAR(150),
"CONTDEALFLAG"VARCHAR(1),
"MOBILEPHONE"VARCHAR(15),
"PREPAIDFLAG"VARCHAR(1),PRIMARY KEY("CASENO")
);--End of generated script for 10.136.1.5-DB2-LIS (db2inst1)