Mgiepz/saiku-adhoc — Issue #98: IBM DB2 SQL Error on rowlimit query
Author: DavideVillaGEP
Created: 2012-02-16 09:57:37+00:00
State: open

hi,
I'm testing the pentaho plugin.
I have no problem with the sample database and I made some report with it.
I'm trying to perform an adhoc report on a new JDBC SQL connection over a IBM DB2 server (AS400) and my DB server complain about a unrecognised keyword: TOP 100
I think the cause is the different handling of the row limit clause of the DB2 SQL dialect, so I try to perform the query with NONE as the rowlimit parameter but it seems this parameter remain set to 100.
is it possible to avoid passing the query limit to the generated SQL query?
this is my only blocker to setup a pentaho test server.
thanks.