Moving the CONTINUEIF up before the INTO line works!
Don't know if the order of the entries in the control file are really documented but the following works:
OPTIONS (ERRORS=999999, ROWS=1000)
LOAD DATA
TRUNCATE
CONTINUEIF LAST PRESERVE <> "^Y"
INTO TABLE AAA
FIELDS TERMINATED BY "|"




Reply With Quote