If you use the owner name as one of the selection criteria to access database object information from one of the system catalog tables, the owner name is case sensitive. You enclose owner in quotation marks, and you must type the owner name exactly as it is stored in the system catalog table. Of the following two examples, only the second successfully accesses information on the table Kaths.table1.
SELECT * FROM systables WHERE tabname = 'tab1' AND owner = 'kaths'; SELECT * FROM systables WHERE tabname = 'tab1' AND owner = 'Kaths';
User informix is the owner of the system catalog tables.