Language Reference Guide

Go Up to User Guides

This reference guide covers the InterBase elements.

Note: For a listing of functions provided in the InterBase UDF library, see Working with UDFs and Blob Filters.

Topics

• Using the InterBase Language Reference
  • Who Should Use this Book
  • Topics Covered in This Book
• SQL Statement and Function Reference
  • SQL Flavors
  • SQL Dialects
  • Database Object Naming Conventions (Language Reference Guide)
  • Statement List
  • Function List (Language Reference Guide)
  • Data Types (Language Reference Guide)
  • Exact Numerics (Language Reference Guide)
  • Error Handling
  • Statement and Function Reference (Language Reference Guide)
• Procedures and Triggers
  • Creating Triggers and Stored Procedures
  • Statement Types Not Supported
  • Nomenclature Conventions
  • Assignment Statement
  • BEGIN … END
  • Comment
  • DECLARE VARIABLE
  • EXCEPTION
  • EXECUTE PROCEDURE (Procedures)
  • EXECUTE STATEMENT
  • FOR SELECT…DO
  • IF…THEN … ELSE
  • Input Parameters (Procedures)
  • NEW Context Variables
  • OLD Context Variables
  • Output Parameters (Procedures)
  • POST_EVENT
  • SELECT (Procedures)
  • SUSPEND
  • WHEN … DO
  • WHILE … DO
• Keywords
  • InterBase Keywords
• Error Codes and Messages
  • Error Sources
  • Error Reporting and Handling
  • SQLCODE Error Codes and Messages
  • InterBase Status Array Error Codes
• System Tables, Temporary Tables, and Views
  • Overview of System Tables, Temporary Tables, and Views
  • System Tables
  • System Temporary Tables
  • System Views
  • Change Views (Reference)
• Character Sets and Collation Orders
  • InterBase Character Sets and Collation Orders
  • Specifying Character Sets