Re: _temptable filling up rootdbs

Posted in 2003

Steve Harrison — 12 Nov 2003 18:09:29 -0800 — source: Usenet: comp.databases.informix

Jordan, I am seeing the same in a program running in Informix on HP-UX and running a java program. When I run the sql in dbaccess, only the temp space is used, when run in java (jdbc) the rootdbs gets filled up while looping through the result set (using a cursor), but the _temptable uses space in both the temp space and the rootdbs as it goes along. If you find a solution could you please let me know. Thanks, Steve.