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.

Chapter	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