i imported a CSV file with 80 lines, where almost everything worked fine according to the report logs:
Thread (21) Import Started [01.03.2010 15:00:01]
Thread (21) Processing “sofa02.csv” into “INVOICE.SPECIALCOSTS”
Thread (21) Reading from file sofa02.csv
Thread (21) Inserting row 80 into table SPECIALCOSTS
The following error(s) occurred. Do you want to ignore the current error(s) and any additional errors and continue importing? Toad will not prompt you again if another error occurs.
Continuing import regardless of the error:
Failed inserting row 1 : [IBM] CLI0111E Numeric value out of range. SQLSTATE=22003
Error(s) occured, 79 out of 80 rows were imported and have been committed.
The error came from the first line, i was thinking. Checking the import afterwards showed me, that only the FIRST record has inserted. The rest has been skipped.
Can anyone check this please? I attached DDL for the Table & the CSV file with the import file created.
Message was edited by: DocJones: Bold’ed a line with possible errorneous data: “Inserting row 80…”
sofa.tim (1007 Bytes)
sofa02.csv (17.1 KB)
Specialcosts.sql (779 Bytes)