control file example

OPTIONS(SKIP=1)

LOAD DATA

REPLACE

INTO TABLE INV.XXINV_ITEM_ATTACH_BEK_REG

TRAILING NULLCOLS

(

  PROCESS_FLAG        TERMINATED BY '|' "TRIM(:PROCESS_FLAG)",      

  TRANSACTION_TYPE    TERMINATED BY '|' "TRIM(:TRANSACTION_TYPE)",      

  SET_PROCESS_ID      TERMINATED BY '|' "TRIM(:SET_PROCESS_ID)",        

  SEGMENT1            TERMINATED BY '|' "TRIM(:SEGMENT1)",              

  PRIMARY_UOM_CODE    TERMINATED BY '|' "TRIM(:PRIMARY_UOM_CODE)",      

  DESCRIPTION         TERMINATED BY '|' ENCLOSED BY '"' "TRIM(:DESCRIPTION)",           

  TEMPLATE_ID         TERMINATED BY '|' "TRIM(:TEMPLATE_ID)",          

  ORGANIZATION_ID     TERMINATED BY '|' "TRIM(:ORGANIZATION_ID)",      

  MASTER_ORG_ID       TERMINATED BY '|' "TRIM(:MASTER_ORG_ID)" ,

  REQUEST_ID          DEFAULTIF REQUEST_ID=BLANKS,

  RECORD_ID           SEQUENCE(MAX,1) 

)