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. You can display remote tracing as well as a description of the query execution plan:
SET OPTION cis_option = 6
