Hi Tobias, I've had a look at your suggestion.
I reckon that this limitation (only tables "T" and views "V") originates from the original DB2 integration contribution by Espen Stromsnes. My DB2 knowledge is only very limited, but from the official documentation here: http://pic.dhe.ibm.com/infocenter/db2luw/v9r7/topic/com.ibm.db2.luw.sql.ref.doc/doc/r0001063.html I take that there are a lot more table types in DB2 catalogs. Is there any reason to limit table types in jOOQ-meta at all? Or should we just drop this predicate? Any ideas? Cheers Lukas 2012/11/24 Tobias Hühner <[email protected]>: > I think it could be a nicee thing to support CGTT and MQT on DB2. > > -- > class DB2Database > .. > protected List<TableDefinition> getTables0() throws SQLException { > ... > - q.addConditions(Tables.TYPE.in("T", "V")); // tables and views > + q.addConditions(Tables.TYPE.in("T", "V", "G", "S")); // tables, > views, CGTT and MQT > > -> > http://www.ibm.com/developerworks/data/library/techarticle/dm-0912globaltemptable/index.html > -> http://publib.boulder.ibm.com/infocenter/db2luw/v9r5/index.jsp: create > table statement > > Tobias
