Using Caché SQL

	Contents
Chapter 1:	Introduction to Caché SQL
	1.1 Architecture 1.2 Features 1.2.1 SQL-92 Compliance 1.2.2 Extensions 1.3 Interoperability 1.3.1 JDBC 1.3.2 ODBC 1.3.3 Embedded SQL 1.3.4 Dynamic SQL 1.3.5 The Caché SQL Gateway
Chapter 2:	Configuration
	2.1 SQL Options 2.2 ODBC Configuration 2.2.1 ODBC Environment Variables and Logging 2.2.2 Windows Client Management 2.2.3 UNIX Client Management 2.3 JDBC Client Configuration
Chapter 3:	Caché SQL Basics
	3.1 Tables 3.2 Queries 3.3 Privileges 3.4 Identifiers 3.4.1 UNICODE Identifiers 3.4.2 Delimited Identifiers 3.4.3 SQL Reserved Words 3.5 Collation 3.5.1 Collation of Indexed Values 3.5.2 Legacy Collation Functions
Chapter 4:	Defining Tables
	4.1 Defining Tables Using Classes 4.2 Defining Tables Using DDL 4.2.1 Using DDL in Embedded SQL 4.2.2 Executing DDL Using Dynamic SQL 4.2.3 Running DDL Scripts from the Command Line
Chapter 5:	Views
	5.1 Updatable Views 5.1.1 The WITH CHECK Option 5.2 Read-Only Views
Chapter 6:	Indices
	6.1 Defining Indices 6.1.1 Defining Indices using a Class Definition 6.1.2 Defining Indices using DDL 6.2 Standard Indices 6.2.1 Indices on Multiple Properties 6.2.2 Unique Indices 6.2.3 Storing Data with Indices 6.3 Bitmap Indices 6.3.1 Bitmap Index Operation 6.3.2 Defining Bitmap Indices using a Class Definition 6.3.3 Defining Bitmap Indices using DDL 6.3.4 Restrictions on Bitmap Indices 6.3.5 Choosing Index Type 6.4 Building Indices 6.4.1 Building Indices with the System Management Portal 6.4.2 Building Indices Programmatically
Chapter 7:	Querying the Database
	7.1 The SELECT Statement 7.1.1 The SELECT List 7.1.2 The FROM Clause 7.1.3 The WHERE Clause 7.1.4 The ORDER BY Clause 7.2 Free-text Search 7.2.1 Full Text Indexing and Text Retrieval through SQL 7.2.2 Collection Indexing and Querying Collections through SQL 7.2.3 Usage Notes and Restrictions 7.3 JOIN 7.3.1 OUTER JOIN Limitations
Chapter 8:	Modifying the Database
	8.1 INSERT Statements 8.2 UPDATE Statements 8.3 DELETE Statements
Chapter 9:	Embedded SQL
	9.1 The Macro Preprocessor 9.2 Syntax and Use 9.2.1 The &sql Directive 9.2.2 Schema Name Resolution 9.2.3 Literal Values 9.2.4 Host Variables 9.2.5 Data Format 9.2.6 Simple SQL Statements 9.2.7 SQL Cursors 9.2.8 The SQLCODE Variable and Error Handling 9.2.9 The %ROWCOUNT Variable 9.2.10 The %ROWID Variable 9.2.11 NULL Handling
Chapter 10:	Dynamic SQL
	10.1 Dynamic SQL versus Embedded SQL 10.2 The %Library.ResultSet Class 10.2.1 Creating a %Library.ResultSet Object 10.2.2 Preparing a Query 10.2.3 Finding Meta-information about a Query 10.2.4 Executing a Query 10.2.5 Fetching Data from a Query 10.2.6 Closing a Query 10.3 The Query Cache
Chapter 11:	Optimizing Performance
	11.1 Indices 11.2 EXTENTSIZE and SELECTIVITY 11.2.1 EXTENTSIZE 11.2.2 SELECTIVITY
Chapter 12:	Foreign Keys

Chapter 13:	Triggers
	13.1 Defining Triggers 13.2 Trigger Code
Chapter 14:	Stored Procedures
	14.1 Defining Stored Procedures 14.1.1 Defining a Stored Procedure Within a Class Definition 14.1.2 Defining a Stored Procedure Using DDL 14.2 Using Stored Procedures 14.2.1 Stored Functions
Chapter 15:	BLOBs, CLOBs, and Streams
	15.1 Defining BLOBs and CLOBs Using DDL 15.2 Using BLOBs and CLOBs within Caché Methods 15.3 Using BLOBs and CLOBs from ODBC 15.4 Using BLOBs and CLOBs from JDBC
Chapter 16:	External Tables

Chapter 17:	Users, Roles, and Privileges
	17.1 Users 17.2 Roles 17.3 Privileges
Chapter 18:	Special Features
	18.1 Implicit Joins 18.1.1 References 18.2 Syntax 18.2.1 COUNT(*) with Additional Columns 18.3 Functions and Operators 18.3.1 %ID 18.3.2 %STARTSWITH 18.4 User-defined Functions