Compatibility with Other Sybase Databases

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

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

• About SQL Anywhere
  SAP Sybase IQ is an extension of SQL Anywhere.
• An Overview of Transact-SQL Support
  SAP 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 SAP Sybase IQ Architectures
  Adaptive Server Enterprise, SQL Anywhere, and SAP Sybase IQ are complementary products, with architectures designed to suit their distinct purposes.
• Data Types
  Adaptive Server Enterprise, SQL Anywhere and SAP Sybase IQ treat data types differently.
• Data Definition Language
  Differences exist between Adaptive Server Enterprise, SQL Anywhere, and SAP Sybase IQ in how you create databases and database objects.
• Data Manipulation Language
  Query requirements differ between Adaptive Server Enterprise, SQL Anywhere, and SAP 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 SAP Sybase IQ provide aids for translating statements between the Watcom-SQL and Transact-SQL dialects.
• Result Sets from Transact-SQL Procedures
  SQL Anywhere, SAP Sybase IQ procedures and Transact-SQL procedures return result sets differently.
• Variables in Transact-SQL Procedures
  SQL Anywhere and SAP 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 SAP Sybase IQ Differences and Shared Functionality
  SAP 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 SAP Sybase IQ Differences and Shared Functionality
  SAP Sybase IQ and Adaptive Server Enterprise have differences in stored procedure support and views support.