ASA SQL User's Guide
Accessing Remote Data
Troubleshooting remote data access
If you are faced with some type of problem with the way Adaptive Server Anywhere is handling a query against a remote table, it is usually helpful to understand how Adaptive Server Anywhere is executing that query. You can display remote tracing as well as a description of the query execution plan:
SET OPTION cis_option = 7