Getting one row with SELECT

With Informix^®, you must use the system table with a condition on the table id:

SELECT user FROM systables WHERE tabid=1

With IBM^® DB2^®, you have to do this:

SELECT user FROM SYSIBM.SYSTABLES WHERE NAME='SYSTABLE'