Re: Tables in a database, mode ANSI

Nils Myklebust wrote: > > Mark Fisher <fisherm@britannic.co.uk> wrote: > > :Is it possible to have 2 tables of the same name but owned by > :2 different users on 1 database? > : > :e.g. "fred".table1 & "jane".table1 both on db1 > : > :I tried it, and got an error, but wanted to make sure I was > :doing it "right". > > You can in a mode ansi database, but not in a regular Informix one. > I wouldn't ever set up a database as mode ansi. The problems are to > many. > > Most of the time when you have a problem like this you should either > be able to solve it via temporary tables (where each session can have > one of the same name) or some other simple construct. Sometimes an > extra column with the username in a common table may be appropriate. > > If you post something about what you intend to achieve someone might > give you more ideas. > > Nils.Myklebust@idg.no > NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway > My opinions are those of my company > The Informix FAQ is at http://www.iiug.org I used to use mode ANSI but I was forced to abandon it at 7.10. The benefit of allowing separate user schemas, which you need, comes with a heavy price. 1. 4GL 6.02 will not compile some forms. 2. User names are stored in upper case. No problem, you might think, but USER is in lower case on Unix so all your user-selected views fail... This is the killer. I understand Informix themselves have problems with mode ANSI. Strange how the manuals show no examples using it. I suspect it is a tick-list feature. Why can't Informix let us have the bits of mode ANSI separately? At the moment they are a rag-bag of things thought to be needed for ANSI compliance. There are a vast number of other things needed, such as real schemas and catalogs and tons of extra syntax and semantics... Peter -- Peter Lancashire Mail: Peter.Lancashire.PL1@bayer.co.uk Information Systems Specialist, Bayer plc Eastern Way, Bury St Edmunds, Suffolk, IP32 7AH, UK Tel: +44-1635-562258, Fax: +44-1635-562281 All opinions are my own and not those of Bayer plc.