IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_CAS_CLAIMBILL_FTRADEDETAILNO') CREATE INDEX IDX_T_CAS_CLAIMBILL_FTRADEDETAILNO ON T_CAS_CLAIMBILL ( FTRADEDETAILNO );

IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_T_CAS_CLAIMBILL_FSOURCEID') CREATE INDEX IDX_T_CAS_CLAIMBILL_FSOURCEID ON T_CAS_CLAIMBILL ( FSOURCEID );

