Discussion Board for collaboration on QlikView Scripting.
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
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.
This is the one we used, but it was some years ago so this can be a newer version: