Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Thank you. I reinstalled the ODBC driver and the problem got resolved.
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)
Hmm, there is no difference in Direct Discovery between the 32b and 64b versions of QV, which ODBC driver are you using?
Thank you. I reinstalled the ODBC driver and the problem got resolved.