OPTIONS(ERRORS=-1,ROWS=100)
LOAD DATA
CHARACTERSET UTF8
INFILE '$INFILE'
BADFILE '$BADFILE'
APPEND INTO TABLE TB_E2E_IBP_ORDER_FINISH
FIELDS TERMINATED BY '#@&@#'
trailing NULLCOLS 
(
  CUST_ORDER_ID, 
  P6_ID, 
  ORDER_STATUS, 
  FINISH_TIME "to_date(:FINISH_TIME,'YYYY-MM-DD HH24:MI:SS')", 
  FILE_TIME "to_date('$FILE_TIME','YYYY-MM-DD HH24:MI:SS')"
)