Re: 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 For SE you can look in $DBTEMP and guess which table is the one you're interested in. The names are mangled with the mktemp(S) function or similar. Peter -- Peter Lancashire Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 Mail: Peter.Lancashire.PL1@bayer.co.uk My Internet plumbing does not allow me to mail and post news together. Sorry. All opinions are my own and not those of Bayer plc.