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 SQL Anywhere SQL; the only differences are for certain product capabilities that are supported only for Sybase IQ or for SQL 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 statements and functions you can use. Other chapters of this book tell you about the statements you use to perform various administrative tasks.

For complete details of supported functions and statements, see Reference: Building Blocks, Tables, and Procedures and Reference: Statements and Options.