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