Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

ODBC CRASH AS400 MILLION RECORDS

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

2 Replies
andgid
New Contributor

ODBC CRASH AS400 MILLION RECORDS

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

andgid
New Contributor

ODBC CRASH AS400 MILLION RECORDS

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

Community Browser