Re: Silly question time -- with answer (long)

Posted in 1998

Jonathan Leffler — Fri, 24 Apr 1998 21:41:58 -0700 — source: Informix-list mailing list archive (1991-1998)

ANTS wrote: > I wonder in mode ANSI databases, when you write owner.tablename > owner will be capitalized (because of ANSI) and you get table > not found error msg. BUT if you write informix.tablename, informix > won't be capitalized and you get the correct results?? > > Any ideas?? Does informix get special treatments? No, I don't think the user informix gets special treatment. I admit that I have not checked today that you have to write "informix".SysTables to refer to the primary table in the catalogue, but I'm pretty sure you have to do so. Yours, Jonathan Leffler (j.leffler@acm.org) #include <many-aliases.h> > -----Original Message----- > From: jleffler@earthlink.net <jleffler@earthlink.net> > Subject: Silly question time -- with answer (long) > > >I hope you can read the attachment.