[Fwd: Looking at temp tables]

Bob W Maccione wrote: > > Has anyone found a way to allow one process the ability to see a temp table > that was/is created by another process. I know that they don't exist in the > sys* tables but I would think that there is some hidden hook I could get at. > I'm really just interested in the number of rows in the table (to tell that the > process is really adding data to the temp table). > > thanks, > bob maccione > bmaccion@world.std.com There is a way but it could be dangerous... If have version 7.X you can: 1. Create a table with the same schema of the temp table ( say table1 ) 2. View the column partnum of systables corresponding to table1 and write it down in a safe place. 3. View with onstat -g ses #session the partnum corresponding to the temp table 4. Update columm partnum of systables corresponding to table1 with the partnum of the temp table.....This is the dangerous thing! 5. Do a select * from table1 and you have the rows of the temp table 6. REMEMBER to rechange the partnum of table1 to the original value !!! Of course this is not supported by Informix, but I tried it (not in a production environment) and it worked... Gabriela Bellani gbellani@bisel.com.ar