P.S.: I completely removed the datetime strings from the data set and am still getting the same error, so it's definitely something else.
fastinsert returns "Numeric value out of range" error, but insert works
조회 수: 2 (최근 30일)
이전 댓글 표시
Hi! I have a situation where, on precisely the same data set, fastinsert is returning
"Java exception occurred: sun.jdbc.odbc.JdbcOdbcBatchUpdateException: [Microsoft][ODBC SQL Server Driver]Numeric value out of range"
but insert works. Looking at the help for fastinsert I see:
"...fastinsert ... supports more (emphasis added) object types than insert"
and the only exception to that I see documented is
"The fastinsert function only supports dates in U.S. format; that is, dates in mm/dd/yyyy format."
I did have this problem, but I corrected it (at least, the error I was getting before is different than the one cited above).
Is anyone aware of any other (undocumented) fastinsert limitations? Any other ideas?
Thanks!
답변 (0개)
참고 항목
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!