Tracking down temporary tables in IDS 9.4

Posted in 2005

Doug Conrey — Fri, 3 Jun 2005 09:59:09 -0600 — source: Usenet: comp.databases.informix

Is there any way to get more information about a temporary table from outside the creating session? I can see that a temporary table exists, and where it's stored, by running this against sysmaster: select a.tabname, l2date(b.ti_created), hex(partnum), ti_rowsize,ti_nrows from systabnames a, systabinfo b where a.partnum = b.ti_partnum and bitval(ti_flags, '0x0020') = 1; But I'd like a little more information. The columns names/types would be great, and the session that created the table. I'm running IDS 9.40 on AIX 5.2. Any ideas? Thanks. DC sending to informix-list