Re: Temp table location?

Posted in 1997

Benjamin Petersen — Mon, 21 Jul 1997 08:53:45 +0200 — source: Informix-list mailing list archive (1991-1998)

Mark D. Stock wrote: > > Matt Brickley wrote: > > > > 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? Is it stored on disk somewhere so > > that it can be queried, unloaded, or edited? > > Right. Yes it is stored on disk somewhere, and yes your 4GL program can > query, unload and edit it. But it is a private table accessible by your > 4GL program only. > As far as I knoe temp tabels are placed in the DBTEMP path, and by default places in /tmp Benjamin Petersen