Re: Looking at temp tables

Peter.Lancashire.PL1@bayer.co.uk "Peter Lancashire" writes: > 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 Another 'unfortunate' about a temp table is that it has no 'sys*' entries so you cannot get any schema info after you have done your select ... into temp. -- Andy Lennard andy@kontron.demon.co.uk