Chapter 1: Using the InterBase Language Reference
The InterBase Language Reference details the syntax and semantics of SQL and Dynamic SQL (DSQL) statements for embedded applications programming and for isql, the InterBase interactive SQL utility. It also describes additional language and syntax that is specific to InterBase stored procedures and triggers.
Who Should Use this Book
The Language Reference data manipulation, and programming practice. It is a syntax and usage resource for:
- Programmers writing embedded SQL and DSQL database applications.
- Programmers writing directly to the InterBase applications programming interface (API), who need to know supported SQL syntax.
- Database designers who create and maintain databases and tables with isql.
- Users who perform queries and data manipulation operations through isql.
Topics Covered in this Book
The following table lists the chapters in the Language Reference, and provides a brief description of them:
| Chapter | Product | |
|---|---|---|
| Chapter 2: SQL Statement and Function Reference | Provides syntax and usage information for SQL and DSQL language elements. | |
| Chapter 3: Porcedures and Triggers | Describes syntax and usage information for stored procedure and trigger language. | |
| Chapter 4: Keywords | Lists keywords, symbols, and punctuation, that have special meaning to InterBase. | |
| Chapter 5: Error Codes and Messages” | Summarizes InterBase error messages and error codes | |
| Chapter 6: System Tables, Temporary Tables, and Views | Describes InterBase system tables and views that track metadata. | |
| Chapter 7: Character Sets and Collation Orders | Explains all about character sets and corresponding collation orders for a variety of environments and uses. |
- Note: For a listing of functions provided in the InterBase UDF library, see the “Working with UDFs and Blob Filters” chapter in the Developer’s Guide.