Skip to main content
Skip table of contents

DB2 (iSeries) Column labels are ignored


You are using an iSeries Database with the driver in your PocketQuery Datasource and your connection string looks like this:

jdbc:as400://as400;prompt=false;translate binary=true;extended metadata=true

In your SELECT statement you are assigning labels to your columns:

SELECT foo AS "Foo Foo", bar AS "Bar Bar", ...

The resulting table has different column names than the labels you specified.


Set "extended metadata" to "false".

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.