As far as I can remember there was no specific reason for only supporting tables and views.
Espen On Nov 30, 2012 1:29 PM, "Lukas Eder" <[email protected]> wrote: > 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 >
