The information in this appendix is intended 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. Beginning with an overview of Transact-SQL, it compares these databases in several areas to be aware of when you are 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 15.1 with Adaptive Server Enterprise 15.0.3 (and earlier releases), and SQL Anywhere 11.0.1.
You can find additional compatibility information in the following chapters:
Chapter 2, “Database Options,” in Reference: Statements and Options. See Transact-SQL compatibility options.
Chapter 3, “SQL Data Types.” See compatibility information for each data type; also see Data type conversions.
Reference: Statements and Options. See the compatibility information in each command.
Sybase IQ is an extension of SQL 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 SQL Anywhere documentation are supported for Sybase IQ.
The Sybase IQ documentation set calls many, but not all differences. Sybase IQ documentation always supersedes the SQL Anywhere documentation. Except for topics where the Sybase IQ documentation refers you to SQL Anywhere documentation, always refer to the documentation listed as “Documentation for Sybase IQ” in “About This Book,” immediately after the Table of Contents in each Sybase IQ book.
