i am trying to load data from flat file to iq database table. i have given some parameters while load as:
CHECK CONSTRAINTS OFF
DELIMITED BY '|'
ROW DELIMITED BY '#'
WITH CHECKPOINT ON
ON FILE ERROR CONTINUE
Message Log 'c:\msg.log'
Row Log 'c:\row.log';
while loading the data, if a single column in a single row is not matched with the table, all load process stops. it does not insert a single row into the table.
row log file writes some timestamps onluy. no record writes into row log file.
actually i am expecting that the rows which has errors should be written into log file and the other rows should be inserted into table successfully.
but in practicle situation this does not happens.