topic ODBC CRASH AS400 MILLION RECORDS in QlikView

ODBC CRASH AS400 MILLION RECORDS

Sun, 14 Mar 2010 22:30:56 GMT

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

ODBC CRASH AS400 MILLION RECORDS

andgid — Sun, 14 Mar 2010 23:16:58 GMT

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

ODBC CRASH AS400 MILLION RECORDS

andgid — Mon, 15 Mar 2010 08:21:35 GMT

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