IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_MATCHRULE' AND KSQL_COL_NAME IN ('FFETCHPURPOSE'))
ALTER TABLE T_FPM_MATCHRULE ADD (FFETCHPURPOSE VARCHAR(50) DEFAULT 'ExecuteControl' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_MATCHRULE' AND KSQL_COL_NAME IN ('FAPPLYCONDITION'))
ALTER TABLE T_FPM_MATCHRULE ADD (FAPPLYCONDITION NVARCHAR(1024) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_MATCHRULE' AND KSQL_COL_NAME IN ('FAPPLYCONDITIONREAL'))
ALTER TABLE T_FPM_MATCHRULE ADD (FAPPLYCONDITIONREAL NVARCHAR(255) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_FPM_MATCHRULE' AND KSQL_COL_NAME IN ('FAPPLYCONDITIONREAL_TAG'))
ALTER TABLE T_FPM_MATCHRULE ADD (FAPPLYCONDITIONREAL_TAG NCLOB );