Re: [Fwd: Looking at temp tables]

Gabriela Bellani (em02588@bancobisel.com.ar) wrote: : There is a way but it could be dangerous... AAIIIIEEEEEE!!! DO NOT DO THIS! Here is the safe, easy way to tell how many rows are in the user's temp table when you don't know the name of the temp table. onstat -g ses -- find the user you're looking for and note his sessid onstat -g ses <sessid> -- note the partnum of any temp tables listed onstat -t | grep <partnum> June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: on vacation in Mountain View, CA ---- * * Standard disclaimers apply * - Please do not send me requests/questions by mail. When I have the knowledge - and time permits, I try to answer questions on comp.databases.informix, but - travel schedule, time, and volume make responding to personal requests - difficult and often slow. Please call your local Informix Technical Support - organization for assistance with technical issues.