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 

Oracle provides the DUAL table to generate one row only.

SELECT user FROM DUAL 

Solution

Check the BDL sources for "FROM systables WHERE tabid=1" and use dynamic SQL to resolve this problem.