Sybase IQ 12.5 ODBC Driver running joins locally

[fdr_2k]

Hi all,

We are using the Sybase IQ 12.5 on an Unix server and everytime we create a new Query Subject, the only sql type we could use is pass-through. Any other type causes an error. This sql type works fine, but when we create a join between two query subjects, this join is locally processed by the Cognos server (8.3 and 8.4 have the same behaviour).

My problem is that we have more than 4 million rows on the fact table and the performance is awful so far.

Can anyone, please, help me on that?

Thanks in advance.

Felipe David Rosochansky

[tupac_rd]

So, when you import a table from the database, into FM, are you able to test and get back data as is? and what does the SQL statement look like

just select * from datasource.table ??

[fdr_2k]

When the table is imported, the SQL is just like select * from [datasource].table. If I try to test this, I got the following error: "This Query contains an error and can not be executed. RQP-DEV-0060 The source of the query subject aBmtQuerySubject is invalid."

In order to make this work, I have to change the SQL Type to pass-through. After doing this, the SQL works properly.

[tupac_rd]

do any of these help, or you tried them and no luck???

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bSybase+%2bIQ+%2b12.5&uid=swg21342456&loc=en_US&cs=utf-8&cc=us&lang=all

http://www-01.ibm.com/support/docview.wss?rs=3442&context=SS9RTN&q1=%2bSybase+%2bIQ+%2b12.5&uid=swg21339339&loc=en_US&cs=utf-8&cc=us&lang=all