This appendix is provided to ease migration to Sybase IQ from other Sybase databases, and to serve as a guide to creating 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 which you need to be aware of when moving to IQ:
Architecture
Data types
Data definition language
Data manipulation language
Stored procedure language
For brevity, in this appendix we occasionally refer to these products as Enterprise, Anywhere, and IQ.
Compatibility features are addressed in each new version of Sybase IQ. This appendix compares Sybase IQ 12.6 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 the section “Transact-SQL compatibility options”
In Chapter 4, “SQL Data Types” see the compatibility information for each data type, and in 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 IQ documentation set calls out differences in many cases, but not all. The Sybase IQ documentation always supersedes the Adaptive Server Anywhere documentation. Except for topics where the IQ documentation refers you to 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.
