This appendix is provided 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 Adaptive Server Anywhere. Beginning with an overview of Transact-SQL, it compares these databases in several areas that you need to be aware of when moving to Sybase IQ:
Architecture
Data types
Data definition language
Data manipulation language
Stored procedure language
Compatibility features are addressed in each new version of Sybase IQ. This appendix compares Sybase IQ 12.7 with Adaptive Server Enterprise 12.5.2 and Adaptive Server Anywhere 9.0.1.
Compatibility information is also provided in the following chapters:
In Chapter 2, “Database Options,”see “Transact-SQL compatibility options”.
In Chapter 4, “SQL Data Types,” see compatibility information for each data type; also see Data type conversions.
In Chapter 6, “SQL Statements,” see the compatibility information in each command.
Sybase IQ is an extension of Adaptive Server Anywhere. In most cases, SQL syntax, functions, options, utilities, procedures, and other features are common to both products. There are, however, important differences. Do not assume that features described in Adaptive Server Anywhere documentation are supported for Sybase IQ.
The Sybase IQ documentation set calls out differences in many cases, but not all. Sybase IQ documentation always supersedes the Adaptive Server Anywhere documentation. Except for topics where the Sybase IQ documentation refers you to Adaptive Server Anywhere documentation, always refer to the documentation listed as “Documentation for Sybase IQ” in “About This Book,” immediately after the Table of Contents of each Sybase IQ book.
