temp tables

Posted in 2000

ottmar goedecke — Thu, 28 Sep 2000 15:15:39 +0200 — source: Informix-list mailing list archive (1991-1998)

hi, how can i determine all existing temporary tables in an informix instance? thanks ottmar goedecke hdi informationsverarbeitung datanbankadministration podbielskistr. 396 30659 hannover tel 0511/645-4451, fax 0511/645-114451 e-mail: goedecke@hdi.de

↪ replying to ottmar goedecke

"William Pinelo Marin" — 2 Oct 2000 23:16:05 +0200 — source: Informix-list mailing list archive (1991-1998)

you can try with next command: dbaccess sysmaster <<-EOF select tabname, trunc(systabnames.partnum/1048576) dbspace, sysdbspaces.name,ti_nrows from systabnames, sysdbspaces, systabinfo where sysdbspaces.dbsnum = trunc(systabnames.partnum/1048576) and systabinfo.ti_partnum = systabnames.partnum and sysdbspaces.is_temp = 1 EOF regards, William Pinelo Marin System Admin Grupo MAZ, S.A. de C.V. +52(9)9810-510 +52(9)9810-553 fax wpinelo@hotmail.com william.pinelo@supermaz.com.mx

↪ replying to ottmar goedecke

Rudy Fernandes — Wed, 04 Oct 2000 14:27:10 -0400 — source: Informix-list mailing list archive (1991-1998)

I'm not sure, but sysmaster:sysptntab.flags may have the information you are looking for. Regular tables have a value of 0, while temporary tables have a value of 4096. Join (on partnum) with systabnames to get more information on the table (like which database it belongs to) Rudy ottmar goedecke wrote: > hi, > how can i determine all existing temporary tables in an informix instance? > > thanks > ottmar goedecke > hdi informationsverarbeitung > datanbankadministration > podbielskistr. 396 > 30659 hannover > tel 0511/645-4451, fax 0511/645-114451 > e-mail: goedecke@hdi.de