If you are faced with some type of problem with the way Sybase IQ is handling a query against a remote table, it is usually helpful to understand how Sybase IQ is executing that query.
See ”General problems with queries” in SQL Anywhere Server - SQL Usage.