Re: Using INFO in a MODE ANSI database

Jonathan, Thanks for reporting this information to the doc alias! The issue has been added to our errata list, and it will be investigated for inclusion in the next release of the document. Cheers, Jonathan -- Jonathan Ganz ganz@informix.com Writing Manager Informix Software, Inc. voice 415-926-6448 4100 Bohannon Drive pager 415-455-3625 Menlo Park, California 94025 > From jleffler@visa.com Mon Apr 13 15:05 PDT 1998 > To: "'Informix News Group'" <informix-list@iiug.org> > Cc: "'Informix Documentation Mail Alias'" <doc@informix.com> > Subject: Using INFO in a MODE ANSI database > Date: Mon, 13 Apr 1998 15:11:27 -0700 > Encoding: 27 TEXT > > Hi, > > Using DB-Access 7.23.UC4 on Sun Sparc E6000 running Solaris 2.5.1. > > If you use 'INFO TABLES' in a MODE ANSI database, you get a list of tables > with no owner names listed, even when someone other than yourself owns the > tables. > > If you use 'INFO COLUMNS FOR "owner".tablename' as the manual (p1-365 > cross-referencing p1-768 clearly indicates you should be able to do), you > get error -839: Table not found. You get the same message with single > quotes in place of the double quotes, and with no owner name - all of which > are inaccurate responses. I got the same response, unsurprisingly, when I > tried to use the database@server:"owner".table notation too. > > Please can someone at Informix (a) verify this, and (b) get it entered into > PTS as a bug, and (c) get it fixed. > > Or get the documentation fixed to refer to the correct subset of the table > name syntax that is permitted - but that will still involve a bug fix since > it is fairly useless to list the table names without owners in a MODE ANSI > database, and you need to be able to identify different tables with the > same name but different owners in a MODE ANSI database. > > Thanks, > Jonathan Leffler (jleffler@visa.com) #include <bother.ms-exchange.h> > >