If there is an issue with a query against a remote table, it is usually helpful to understand how Sybase IQ executes that query.
See SQL Anywhere Server - SQL Usage > Remote data and bulk operations > Accessing remote data > Troubleshooting remote data access > General problems with queries.