Contents Index Connectivity problems Queries blocked on themselves

ASA SQL User's Guide
  Accessing Remote Data
    Troubleshooting remote data access

General problems with queries


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

Contents Index Connectivity problems Queries blocked on themselves