/**Begin D:\pdm\PDM_UPGRADE\pdm_new\RIM_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INPUT_TABLE' AND KSQL_COL_NAME ='FRESOURCE')
 ALTER TABLE T_RIM_INPUT_TABLE ADD (FRESOURCE NVARCHAR(50) DEFAULT ' ' NOT NULL );
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INPUT_TABLE' AND KSQL_COL_NAME ='FOVERRIDE_ORG')
 ALTER TABLE T_RIM_INPUT_TABLE ADD (FOVERRIDE_ORG NVARCHAR(4) DEFAULT ' ' NOT NULL );
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INPUT_TABLE' AND KSQL_COL_NAME ='FCOLLECT_TYPE')
 ALTER TABLE T_RIM_INPUT_TABLE ADD (FCOLLECT_TYPE NVARCHAR(4) DEFAULT ' ' NOT NULL );

 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_RIM_INPUT_TABLE' AND KSQL_COL_NAME ='FELECTRONIC_NO')
 ALTER TABLE T_RIM_INPUT_TABLE ADD (FELECTRONIC_NO NVARCHAR(30) DEFAULT ' ' NOT NULL );


/**End D:\pdm\PDM_UPGRADE\pdm_new\RIM_table.sql **/
