Thanks for the info, Espen. I guess I'll just remove this predicate and let jOOQ-meta fetch all data from the table catalog
Cheers Lukas 2012/11/30 Espen Strømsnes <[email protected]>: > 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
