Getting one row with SELECT

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

SELECT user FROM systables WHERE tabid=1

With Genero db some statements can be as follows:

PREPARE pre FROM "SELECT USER" EXECUTE pre INTO l_user

Solution

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