Commands and functions

All Sybase IQ commands are SQL statements. SQL stands for Structured Query Language, a language commonly used in database applications. Sybase IQ SQL uses the same syntax as Adaptive Server Anywhere SQL; the only differences are for certain product capabilities that are supported only for Sybase IQ or for Anywhere. Sybase IQ SQL also offers a high degree of compatibility with Transact-SQL, the SQL dialect used by Adaptive Server Enterprise.

This section introduces the types of commands and functions you can use. Other chapters of this book tell you about the commands you use to perform various administrative tasks. For complete details of supported commands and functions, see the Sybase IQ Reference Manual.