OPTIONS(ERRORS=-1,ROWS=100)
LOAD DATA
CHARACTERSET UTF8
INFILE '$INFILE'
BADFILE '$BADFILE'
APPEND INTO TABLE TB_E2E_CRM_PROP_ORDER
FIELDS TERMINATED BY '#@&@#'
trailing NULLCOLS
(
  ROW_ID,
  DATA_TYPE,
  PROP_NAME,
  PROP_VALUE,
  FILE_TIME "to_date('$FILE_TIME','YYYY-MM-DD HH24:MI:SS')"
)