cancel
Showing results for 
Search instead for 
Did you mean: 

Using Explorer 4.0 to access sybase IQ 15.x Universe (unx format) issue

Former Member
0 Kudos

I've used Universe Design tools to build a FinTrade universe which is connected to Sybase IQ 15.x using ODBC. I then use Information Design Tools to convert it to a unx format universe.

However, the query failed with the following error :

The query cannot run because it contains incompatible objects. (WIS 00008)

I've tried to drag one column, and I found that view the scripts as below, with double quotes. If I remove all the double quotes and use the 'custom SQL', it could be validate. However, if I drag more than 2 columns, I was not able to use 'custom SQL'.

Any configuration I could set to remove all the quotes?

SELECT

"DIM_INSTR"."INSTR_NAME"

FROM

"DIM_INSTR"

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I heard that only Sybase IQ 12 ODBC driver is support, and I choose the IQ 12 ODBC driver but it didn't help. My Information tool version is 14.0.2

I've got another VM, which Information Tool version si 14.0.1, and there is no double quote problem, and only sybase IQ 12 ODBC driver could be found. However when I do indexing, it always failed with

Creation Failed (the execution of the specified analysis query failed. [sybase]{ODBC Driver}[SQL Anaywhere] No database file specified. Kindly help.