topic Connecting it with IBM DB2 in QlikView

Connecting it with IBM DB2

Fri, 19 Mar 2010 19:26:37 GMT

Hello,

I am new to QV and its software. However, my company has millions of data stored in IBM 2 server. Can QV support this? Read couple of articles on the site but could not find anything regarding the same.

Thank You all in advance.

-raj

Connecting it with IBM DB2

Anonymous — Fri, 19 Mar 2010 19:53:33 GMT

We've done it. You just need the IBM iSeries ODBC connection software (which is an ugly beast).

Connecting it with IBM DB2

Fri, 19 Mar 2010 20:15:02 GMT

Thanks Brian,

That should help.

Connecting it with IBM DB2

rwunderlich — Fri, 19 Mar 2010 23:32:12 GMT


mayankraj wrote:my company has millions of data stored in IBM 2 server.

ODBC drivers are available for all DB2 platforms. What platform is your DB2 running on (Windows, Linux, zSeries, iSeries)?

-Rob

Connecting it with IBM DB2

Mon, 22 Mar 2010 13:50:53 GMT

Hey Thank You all for the reply. So what if our client is at some location, and we need to run QV 4 from another location? Should we need to remote connect and install QV into their system?

Or there is something other way up? Thanks again.

Re: Connecting it with IBM DB2

Mon, 24 Nov 2014 11:22:00 GMT

Hi Rob,

At my end, DB2 is running on Unix platform and at Qlikview side i do have IBM OLEDB provider for DB2 - DB2COPY1. I am not able to connect to database with this.

Do I need to install IBM OLEDB provider for DB2 driver?

regards,

prachi

Re: Connecting it with IBM DB2

Fri, 24 Jun 2016 19:38:03 GMT

Hi rwunderlich ,

you know how can extract subFiles in File,

Example:

This giveme Rows(load working), but this table hava a subTable inside

SQL Select *

From axscd12."db45at".OBCOP300;

This not working in load.

SQL Select *

From axscd12."db45at".OBCOP300.M010;

you know something about this issue.

Thanks and best regards