Single row SELECT
Informix®
With Informix, you must use the system table with a condition on the table id:
SELECT USER FROM systables WHERE tabid=1 IBM® DB2®
To retrieve a single row with IBM DB2, use the following
syntax:
SELECT CURRENT_USER FROM SYSIBM.SYSTABLES WHERE NAME='SYSTABLES'Solution
Check the BDL sources for "FROM systables WHERE tabid=1" and use dynamic SQL to
resolve this problem.
Consider writing a FUNCTION which produces the FROM and
WHERE part, depending on the target database type.