09-29-05, 07:40 #1Registered User
- Join Date
- Apr 2004
Unanswered: How to get list of all temporary tables?
I can easy get structure of GTT by query DESCRIBE SELECT * FROM SESSION.<GTTNAME>. As everybody knows DECLARE GTT does not apply any changes in SYSCAT.TABLES. So I cannot get list of GTTs.