Loder Control file

OPTIONS(ROWS=10000,ERRORS=2000000,SKIP=1)
LOAD DATA
APPEND INTO TABLE XXMAS.PROMISE_DATES
FIELDS TERMINATED BY ‘|’ OPTIONALLY ENCLOSED BY ‘”‘
TRAILING NULLCOLS
(
ORDER_NUMBER “LTRIM(RTRIM(:ONT_ORDER_NUMBER))”,
SOURCE_SYSTEM “LTRIM(RTRIM(:SOURCE_SYSTEM))”,
ITEM_NUMBER “LTRIM(RTRIM(:ITEM_NUMBER))”,
NEW_PROMISE_DATE Date “YYYYMMDD”,
PO_NUMBER “LTRIM(RTRIM(:PO_NUMBER))”,
PO_LINE_NUMBER_CHAR “LTRIM(RTRIM(:PO_LINE_NUMBER_CHAR))”,
ORDERED_QUANTITY,
INBOUND_ORG_ID,
CONV_REQUEST_ID Constant “-1?,
FILE_REQUEST_ID Constant “-1?,
CONV_STATUS Constant “FILE”,
CREATION_DATE Sysdate,
CREATED_BY Constant “-1?,
LAST_UPDATE_DATE Sysdate,
LAST_UPDATED_BY Constant “-1?,
LAST_UPDATE_LOGIN Constant “-1?,
ERROR_FLAG Constant ‘N’,
LOADED_FLAG Constant ‘N’
)