SQL adaptation guide For IBM DB2 UDB 8.x, 9x / Data manipulation |
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'
Check the BDL sources for "FROM systables WHERE tabid=1" and use dynamic SQL to resolve this problem.