Re: Temp tables not unique?

> Mancunian1@aol.com writes: > Informix 4GL 6.0, Online 5.0, SCO Unix. > > Is it true that a temp table created by a user running a 4GL program becomes > a unique table within the Database for the duration of the process? In other > words another user would bomb out trying to run the same program? No this is not true. Only the user (or realy the process) creating the table can see it. Any number of users can run the same program creating temp tables with the same name in your code. The same user can even run this program any number of times in parallel successfully. By the way: If you realy have OnLine 5.0 you shouldn't be able to use 4GL 6.0 Nils.Myklebust@ccmail.telemax.no NM-data, Aasesvei 71, 1300 Sandvika, Norway My opinions are those of my company