Direct Discovery using DB2 data source

[nagaiank]

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

[nagaiank]

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)

[#3]

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

[nagaiank · Accepted solution]

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