Sybase IQ architecture includes a portion of the product that processes queries according to SQL Anywhere rules called Component Integration Services (CIS). Formerly called OMNI, this feature allows queries not directly supported by Sybase IQ semantics to be processed, but with a major performance cost.
CIS intercepts queries that:
Reference a user-defined function
Include a cross-database join or proxy table
Include certain system functions
Reference a Catalog Store table or a table created in the SYSTEM dbspace
For more information on differences between Sybase IQ and SQL Anywhere, see Appendix A, “Compatibility with Other Sybase Databases,” in Reference: Building Blocks, Tables, and Procedures.
