DB2 (iSeries) Column labels are ignored

Problem

You are using an iSeries Database with the com.ibm.as400.access.AS400JDBCDriver driver in your PocketQuery Datasource and your connection string looks like this:

CODE

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

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

CODE

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

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

Solution

Set "extended metadata" to "false".

Problem

Solution

Related articles