Re: Looking at temp tables

: Anyway, if all you want to do is verify the # of rows and you know the name : of the temp table, you can query the sysmaster tables to get what you want. : This only works for explicitly created temp tables - tables resulting from : "select.....into temp myname" and "create temp table myname...". If you don't know the name of the temp table, check onstat -g ses for the session. It lists temp tables open for the user. You can also do onstat -t, which shows temp tables, but by partnum, and shows number of rows in the table. 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.