/**Begin D:\PDM_UPGRADE\PDM1\EB_table.sql **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BGDECOMPOSE' AND KSQL_COL_NAME ='FDECPSTEP')
 ALTER TABLE T_EB_BGDECOMPOSE ADD (FDECPSTEP  VARCHAR(50) DEFAULT ' ' NOT NULL);
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BGDECOMPOSE' AND KSQL_COL_NAME ='FDECPDATAS')
 ALTER TABLE T_EB_BGDECOMPOSE ADD (FDECPDATAS  VARCHAR(1000) DEFAULT ' ' NOT NULL);
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BGDECOMPOSE' AND KSQL_COL_NAME ='FISFIRSTSTEP')
 ALTER TABLE T_EB_BGDECOMPOSE ADD (FISFIRSTSTEP  CHAR(1) DEFAULT '0' NOT NULL);
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BGDECOMPOSE' AND KSQL_COL_NAME ='FDECPPATH')
 ALTER TABLE T_EB_BGDECOMPOSE ADD (FDECPPATH  VARCHAR(1000) DEFAULT ' ' NOT NULL);
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_BGDECOMPOSE' AND KSQL_COL_NAME ='FALLSPLITORG')
 ALTER TABLE T_EB_BGDECOMPOSE ADD (FALLSPLITORG  NCLOB);
 
 IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DECOMPOSESCHEME' AND KSQL_COL_NAME ='FBIZCTRLRANGE')
 ALTER TABLE T_EB_DECOMPOSESCHEME ADD (FBIZCTRLRANGE   BIGINT DEFAULT 0 NOT NULL);
 
  IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_EB_DECOMPOSESCHEME' AND KSQL_COL_NAME ='FROWSDATA')
 ALTER TABLE T_EB_DECOMPOSESCHEME ADD (FROWSDATA  NCLOB);
 
/**End D:\PDM_UPGRADE\PDM1\EB_table.sql **/