SQL adaptation guide For Sybase ASE 15.5+ / 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 Sybase ASE, you can omit the FROM clause to generate one row only:
SELECT user
Check the BDL sources for "FROM systables WHERE tabid=1" and use dynamic SQL to resolve this problem.