Re: Need help to find missing records in INFORMIX tables

Thanks to all who suggested that I "GRANT SELECT ON table TO [PUBLIC|user]" to overcome the PERFORM problem with rows not being displayed. I know that this is a workaround, but I am reluctant to grant access to public, I consider this a security leak, and it is quite tedious to enter the grant statement for each DBA user for each and every table. I tried to write a short 4GL program using variables for table names, but that didn't work, you can't use variables for table names! I'd prefer that PERFORM worked according to the manuals and accept DBA privileges. Is the current performance a bug or a feature? Regards, Richard -- +----------------------------+-------------------------------------------+ | 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 | | +----------------------------+-------------------------------------------+