display temp tables PER SESSION

Posted in 2010

Tom Lehr — Wed, 3 Nov 2010 11:48:17 -0700 (PDT) — source: Usenet: comp.databases.informix

hello all i am able to return the temp tables created within the database but unable to see how i also include the information of what the session ID is here is the sql to return the partnum, owner and table name - does anyone know how to include the session ID? Thanks Much SELECT partnum, owner, tabname FROM sysmaster:systabnames s,sysmaster:systabinfo i WHERE i.ti_partnum = s.partnum AND sysmaster:BITVAL(i.ti_flags,'0x0020') = 1