hi
i am trying to load data from flat file to iq database table. i have given some parameters while load as:
CHECK CONSTRAINTS OFF
QUOTES OFF
ESCAPES OFF
DELIMITED BY '|'
ROW DELIMITED BY '#'
FORMAT ASCII
WITH CHECKPOINT ON
ON FILE ERROR CONTINUE
PREVIEW ON
SKIP 10
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.

can any one help me in this situation?

waiting for the reply

regards