I have a control file:
CONTINUEIF LAST != "|"
INTO TABLE load_ash_lnids
FIELDS TERMINATED BY "|" OPTIONALLY ENCLOSED BY '"'
REPORT_DT date "DD/MM/YYYY" ,
SUBMITTED_DATE date "DD/MM/YYYY",
RDD_DATE date "DD/MM/YYYY",
EDD_DESTINATION_DATE date "DD/MM/YYYY",
COMMENTS CHAR(4000) "replace(:COMMENTS,'\\n',chr(10))",
But it is randomly skipping random records. Although if then load the records that did load, they load (had to keep doing this, as each time recordes still weren't loaded. There was meant to be 128 records, but only 111 were loading. No errors occured.
jamjcam, without a sample input file that reproduces the behavior in question you have left forum readers with no real choice but to guess at the issue. My guess is that your data does not properly match to your CONTINIEIF condition where the file lines are to be conbined into a single row of data.