Connecting it with IBM DB2

[#1]

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

[Anonymous · Accepted solution]

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

[#3]

Thanks Brian,

That should help.

[rwunderlich]

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

[#5]

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.

[#6]

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

[#7]

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