Re: temp table existence

Posted in 2005

Rajib Sarkar — Wed, 9 Nov 2005 13:10:29 -0700 — source: Usenet: comp.databases.informix

Short answer ..onstat -g ses <sessionnum> should be able to tell u that. Other than that I'd written a script long back to connect a temp table to a session .. I'm attaching it for ur perusal (I've not tested it with the latest releases ..so I'm not sure if it'll work or not). (See attached file: find_temp_tables.ksh) Thanx much, Rajib Sarkar DB2 UDB RPD Team IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 T/L : 667-2100 http://www.ibm.com/software/data/db2/udb/support/

Related threads

Posting from the Informix-list
Migrating from IDS 9.40.UC6 to 11.50.UC3
Ip for a network session
questions onstat -g