ibp_receive_ctl.vm
359 Bytes
OPTIONS(ERRORS=-1,ROWS=100)
LOAD DATA
CHARACTERSET UTF8
INFILE '$INFILE'
BADFILE '$BADFILE'
APPEND INTO TABLE TB_E2E_IBP_ORDER_RECEIVE
FIELDS TERMINATED BY '#@&@#'
trailing NULLCOLS
(
CUST_ORDER_ID,
VERSION_ID,
IBP_RECEIVE_CRM_TIME "to_date(:IBP_RECEIVE_CRM_TIME,'YYYY-MM-DD HH24:MI:SS')",
FILE_TIME "to_date('$FILE_TIME','YYYY-MM-DD HH24:MI:SS')"
)