/**Begin D:\PDM_UPGRADE\PDM1\SOEHRR_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_RPTTPL' AND KSQL_COL_NAME ='FISLOCKSAMPLE')
ALTER TABLE T_SOEHRR_RPTTPL ADD (FISLOCKSAMPLE CHAR(1) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_RPTTPLENTRY' AND KSQL_COL_NAME ='FSAMPLEJSON')
ALTER TABLE T_SOEHRR_RPTTPLENTRY ADD (FSAMPLEJSON VARCHAR(255) );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_SOEHRR_RPTTPLENTRY' AND KSQL_COL_NAME ='FSAMPLEJSON_TAG')
ALTER TABLE T_SOEHRR_RPTTPLENTRY ADD (FSAMPLEJSON_TAG NCLOB );

/**End D:\PDM_UPGRADE\PDM1\SOEHRR_table.sql **/