topic Re: Direct Discovery using DB2 data source in QlikView

Direct Discovery using DB2 data source

nagaiank — Fri, 14 Mar 2014 17:50:32 GMT

Is Direct Data Discovery supported for DB2 using ODBC 32 connection string?

I am able to load data using the following script:

ODBC CONNECT32 ...

SQL SELECT field1, field2, .... from database table name;

But when I want to load data on demand using Direct Discovery using the script

DIRECT QUERY

DIMENSION

field1, field2

MEASURE

field10, field11

DETAIL

field20, field21, ....

FROM database table name

I get the following error:

SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][CLI Driver][DB2/SUN64] SQL0204N

What am I doing wrong?

Appreciate your help

Re: Direct Discovery using DB2 data source

nagaiank — Tue, 18 Mar 2014 17:03:49 GMT

I get the above error while using QV 11SR5 in Windows 7 (64bit) with ODBC 32 bit driver.

The same script works successfully in QV11 SR5 in Windows XP (32 bit) with ODBC 32 bit driver.

I do not if the problem in the OS or ODBC driver or QV11SR5 with Windows7 and ODBC32 driver.

However, I have no error in using QV11SR5 in Windows7 and ODBC32 driver for other data extracts (other than DIRECT QUERY ... DIMENSION ... MEASURE ... DETAIL ... syntax)

Re: Direct Discovery using DB2 data source

Thu, 24 Apr 2014 16:17:46 GMT

Hmm, there is no difference in Direct Discovery between the 32b and 64b versions of QV, which ODBC driver are you using?

Re: Direct Discovery using DB2 data source

nagaiank — Thu, 24 Apr 2014 16:53:55 GMT

Thank you. I reinstalled the ODBC driver and the problem got resolved.