Problem:
Using ODBC with DB2 and not being the owner of the table, how to specify a qualifer for the table?
Resolution:
This is specified by the configuration of the DB2 ODBC datasource through the ODBC Data Sources tool. Select the datasource, click on Advanced Settings tab, hit the ADD button
Select the CLI\\ODBC parameter of CurrentSchema (or CurrentSQLID) then specify the default qualifier.