org_type.ctl LOAD DATACHARACTERSET AL32UTF8INFILE 'C:\opt\data\ORG_TYPE.txt' replace INTO TABLE dbp_uom_org_typeFIELDS TERMINATED BY '\t'TRAILING NULLCOLS (ORG_TYPE_ID,ORG_ID,ORG_TYPE_CD,EFF_DATE FILLER,EXP_DATE FILLER,STATUS_CD,STATUS_DATE
LOAD DATA CHARACTERSET AL32UTF8 INFILE 'C:\opt\data\ORG_TYPE.txt' replace INTO TABLE dbp_uom_org_type FIELDS TERMINATED BY '\t' TRAILING NULLCOLS ( ORG_TYPE_ID, ORG_ID , ORG_TYPE_CD , EFF_DATE FILLER, EXP_DATE FILLER, STATUS_CD , STATUS_DATE FILLER, CREATE_STAFF FILLER , CREATE_DATE FILLER, UPDATE_STAFF FILLER, UPDATE_DATE "sysdate", SERIAL "1000000000000" )