Re: Need help to find missing records in INFORMIX tables

Richard Spitz writes: } joseph,leland w (leland@donner.cc.bellcore.com) wrote: } } : I have a problem with one of my INFORMIX tables. I cannot retrieve records } : using PERFORM that I know exists in the table. When I submit an ACE program, } : I can retrieve the records. } } Sorry, I don't have a solution, but I am experiencing a similar problem. } Certain PERFORM masks let me query for data, and they display "XXX records } found", but the data are not displayed! I can browse through the data } with the "Forward" and "Backward" menu items, but no data are ever dis- } played! } } This happens when I am querying as a user who is not owner of the table, } but has DBA privileges on the database! } } When I su to the owner of the table, the PERFORM mask displays the data } just fine. For some unknown reason, PERFORM actually checks the table permissions of the user. Being DBA is not good enough, you must actually have SELECT permission on the table in order for PERFORM to display the values. As you saw, PERFORM will still query and tell you how many rows were retrieved, but the data appears to be blank. All the other related products seem to display the values if you are DBA, but PERFORM does not. PERFORM does not require that you must be the owner of the table, but the owner or user "informix" must have granted you select permission for the table. } +----------------------------+-------------------------------------------+ } | Dr. Richard Spitz | INTERNET: spitz@ana.med.uni-muenchen.de | } | EDV-Gruppe Anaesthesie | Tel : +49-89-7095-3421 | } | Klinikum Grosshadern | FAX : +49-89-7095-8886 | } | Munich, Germany | | } +----------------------------+-------------------------------------------+ -- Bryan Klopfenstein bryan@carsinfo.com CARS Information Systems, Inc. Cincinnati, OH Standard Disclaimers Apply