Re: Temp table location?

>From: Matt Brickley <mbrickley@infoave.net> >Date: Thu, 17 Jul 1997 13:28:27 -0400 >X-Informix-List-Id: <news.40559> > >On SE 5.01/SCO Unix 3.2v4.2 > >When you create a temp table in a 4gl program, it only exists for the >duration of the program right? Yes. >Is it stored on disk somewhere... Yes; in ${DBTEMP:-/tmp} (unless the docs say /usr/tmp or somewhere else is the default). >...so that it can be queried, unloaded, or edited? It can be queried and unloaded inside the program which creates it, but not in any other program -- it is completely private to the process which creates it. Hence, if you mean 'INSERT, DELETE and UPDATE' as editing operations, then yes; if you mean 'can I run vi on it', then no, not least because you can't find out what the file name is. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> PS: Warning I do not reply to messages with anti-spam in the return path.