Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a big problem.
I need to import 25 million records with ODBC AS400(Iseries) driver
After loading of 8.533.247 records the odbc driver crash
The load crash always at the same point.
Probably I have to set the ODBC data-package
Someone know what I have to do ?
Many Many Thanks
Claudio
I had a problem with AS400 ODBC drivers for some years ago. Qlikview wasn't included that time, just importing data via ODBC.
To be able to import all the records I needed to increase the timeout value in the odbc-driver settings.
But that odbc-driver could have been another then the one you're using. I can check what manufacturer we bought that one from when I come in to the office in about 8-9 hours.
Regards,
/Anders
Hi again,
This is the one we used, but it was some years ago so this can be a newer version:
http://www.hitsw.com/products_services/sql400/odbc400/odbc400_dsheet.html
Regards,
/Anders