Compatibility with Other Sybase Databases

Use the topics in this section to simplify migration to Sybase IQ from other Sybase databases, and to serve as a guide for creating Sybase IQ applications that are compatible with Adaptive Server Enterprise or SQL Anywhere.

Compatibility features are addressed in each new version of Sybase IQ. This appendix compares Sybase IQ with Adaptive Server Enterprise, and SQL Anywhere.

• About SQL Anywhere
  Sybase IQ is an extension of SQL Anywhere.
• An Overview of Transact-SQL Support
  Sybase IQ, like SQL Anywhere, supports a large subset of Transact-SQL, which is the dialect of SQL supported by Sybase Adaptive Server Enterprise.
• Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ Architectures
  Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ are complementary products, with architectures designed to suit their distinct purposes.
• Data Types
  Adaptive Server Enterprise, SQL Anywhere and Sybase IQ treat data types differently.
• Data Definition Language
  Differences exist between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ in how you create databases and database objects.
• Data Manipulation Language
  Query requirements differ between Adaptive Server Enterprise, SQL Anywhere, and Sybase IQ.
• Transact-SQL Procedure Language Overview
  The stored procedure language is the part of SQL used in stored procedures and batches.
• Automatic Translation of Stored Procedures
  In addition to supporting Transact-SQL alternative syntax, SQL Anywhere and Sybase IQ provide aids for translating statements between the Watcom-SQL and Transact-SQL dialects.
• Result Sets from Transact-SQL Procedures
  SQL Anywhere/Sybase IQ procedures and Transact-SQL procedures return result sets differently.
• Variables in Transact-SQL Procedures
  SQL Anywhere and Sybase IQ assign values to variables in procedures differently than Transact-SQL.
• Error Handling in Transact-SQL Procedures
  Default procedure error handling is different in the Watcom-SQL and Transact-SQL dialects.
• SQL Anywhere and Sybase IQ Differences and Shared Functionality
  Sybase IQ and SQL Anywhere have differences in starting and managing databases and servers, database option support, DDL support, and DML support.
• Adaptive Server Enterprise and Sybase IQ Differences and Shared Functionality
  Sybase IQ and Adaptive Server Enterprise have differences in stored procedure support and views support.