on 10-25-2011 9:15 AM
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"
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.