Thank you in advance for taking a look at this and possibly helping me out!!
I have 2 Input files in my control file. I am trying to skip the first row in each input file. It does skip the 1st row in the 1st file, but not in the 2nd. I added a WHEN to try make it skip the header, but that also has undesirable results.
************* control file *****************************
OPTIONS (SKIP=1)
LOAD DATA
INFILE '/appl/law10/law/importfiles/Tecsys/SQLLoader/ReceivingProductivity-en-zw-PKG.csv' BADFILE '/appl/law10/law/importfiles/Tecsys/SQLLoader/PKG.bad' DISCARDFILE '/appl/law10/law/importfiles/Tecsys/SQLLoader/PKG.dsc'
INFILE '/appl/law10/law/importfiles/Tecsys/SQLLoader/ReceivingProductivity-en-zw-REPL.csv' BADFILE '/appl/law10/law/importfiles/Tecsys/SQLLoader/REPL.bad' DISCARDFILE '/appl/law10/law/importfiles/Tecsys/SQLLoader/REPL.dsc'
APPEND INTO TABLE "ENTERPRISE_REPORT"."RECEIVING_PRODUCTIVITY"
WHEN TYPE <> '2'
FIELDS TERMINATED BY "|" --OPTIONALLY ENCLOSED BY '"' --COMMA
TRAILING NULLCOLS
(
RECEIVER,
DATE_RECEIVED DATE "MM-DD-YYYY" ":DATE_RECEIVED",
HOUR_RECEIVED,
LINE_COUNT,
TYPE
)