@mariomarf Have you been successful in using Superset with a DB2 database? 
After making manual fixes to the ibm_db_sa package (see this 
[issue](https://github.com/ibmdb/python-ibmdb/issues/320)), I still run into 
lots of issues due to SQL Lab parsing the query and adding `LIMIT` clauses, 
when DB2 expects `FETCH FIRST X ROWS ONLY`.  For example, if after running a 
query I click on the tab for "Preview for [database]", I get the following 
error:

`
ibm_db_dbi::ProgrammingError: SQLNumResultCols failed: [IBM][CLI 
Driver][DB2/LINUXX8664] SQL0104N An unexpected token "LIMIT 1000000" was found 
following "FIRST 100 ROWS ONLY". Expected tokens may include: "<space>". 
SQLSTATE=42601 SQLCODE=-104
`

I'll open a separate issue, but I'm not sure if it's an external bug with 
ibm_db_sa or Superset.

[ Full content available at: 
https://github.com/apache/incubator-superset/issues/5063 ]
This message was relayed via gitbox.apache.org for [email protected]

Reply via email to