Using Caché SQL
Contents
[Home]  [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

Preface : 
 
 
Chapter 1: 
 
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.4 Limitations
Chapter 2: 
 
2.1 Tables
       2.1.1 Schemas
2.2 Queries
2.3 Privileges
2.4 Data Display Options
2.5 Data Collation
2.6 Executing SQL
Chapter 3: 
 
3.1 Commands and Keywords
3.2 Literals
       3.2.1 String Delimiters
       3.2.2 Concatenation
3.3 NULL and the Empty String
3.4 Arithmetic Operators and Functions
3.5 Relational Operators
3.6 Logical Operators
3.7 Comments
Chapter 4: 
 
4.1 Simple Identifiers
4.2 Delimited Identifiers
4.3 SQL Reserved Words
Chapter 5: 
 
5.1 Table Names and Schema Names
5.2 RowID Field
5.3 RowVersion and Serial Counter Fields
       5.3.1 RowVersion Field
       5.3.2 Serial Field
5.4 Defining a Table by Creating a Persistent Class
       5.4.1 Unique Values
       5.4.2 Computed Values
       5.4.3 Class Methods
5.5 Defining a Table by Using DDL
5.6 Defining a Table by Querying an Existing Table
5.7 External Tables
5.8 Listing Tables
5.9 Listing Column Names and Numbers
Chapter 6: 
 
6.1 Creating a View
6.2 Updateable Views
6.3 Read-only Views
6.4 View ID: %VID
6.5 Listing View Properties
6.6 Listing View Dependencies
Chapter 7: 
 
7.1 Defining a Foreign Key
7.2 Foreign Key Referential Integrity Checking
7.3 Identifying Parent and Child Tables
Chapter 8: 
 
8.1 INSERT Statements
8.2 UPDATE Statements
8.3 DELETE Statements
8.4 Transaction Processing
Chapter 9: 
 
9.1 Types of Queries
9.2 Using a SELECT Statement
9.3 Defining and Executing Named Queries
       9.3.1 CREATE QUERY and CALL
       9.3.2 Class Queries
9.4 Queries Invoking User-defined Functions
9.5 Collection Properties
9.6 Queries Invoking Free-text Search
9.7 Pseudo-Field Variables
9.8 Query Metadata
9.9 Queries and ECP
Chapter 10: 
 
10.1 Collation Types
10.2 Namespace-wide Default Collation
10.3 Table Field/Property Definition Collation
10.4 Index Definition Collation
10.5 Query Collation
10.6 Legacy Collation Types
10.7 SQL and NLS Collations
Chapter 11: 
 
11.1 Property Reference
11.2 Child Table Reference
11.3 Arrow Syntax Privileges
Chapter 12: 
 
12.1 Compiling Embedded SQL and the Macro Preprocessor
12.2 Embedded SQL Syntax
12.3 Embedded SQL Code
12.4 Host Variables
12.5 SQL Cursors
12.6 Embedded SQL Variables
       12.6.1 %msg
       12.6.2 %ok
       12.6.3 %ROWCOUNT
       12.6.4 %ROWID
       12.6.5 SQLCODE
       12.6.6 $TLEVEL
       12.6.7 $USERNAME
12.7 Auditing Embedded SQL
Chapter 13: 
 
13.1 Introduction to Dynamic SQL
13.2 The %SQL.Statement Class
13.3 Creating an Object Instance
13.4 Preparing an SQL Statement
13.5 Executing an SQL Statement
       13.5.1 %Execute()
       13.5.2 %ExecDirect()
13.6 Returning the Full Result Set
13.7 Returning Specific Values from the Result Set
13.8 Returning Multiple Result Sets
13.9 SQL Metadata
13.10 Auditing Dynamic SQL
Chapter 14: 
 
14.1 Dynamic SQL Using %ResultSet.SQL
14.2 Dynamic SQL Using %Library.ResultSet
14.3 Input Parameters
14.4 Closing a Query
14.5 %Library.ResultSet Metadata
14.6 %ResultSet.SQL Metadata
Chapter 15: 
 
15.1 Other Ways of Executing SQL
15.2 Invoking the SQL Shell
15.3 Storing and Recalling SQL Statements
       15.3.1 Recall by Number
       15.3.2 Recall by Name
15.4 SQL Shell Parameters
15.5 SQL Metadata and Performance Metrics
15.6 Transact-SQL Support
       15.6.1 Setting DIALECT
       15.6.2 Setting COMMANDPREFIX
       15.6.3 RUN Command
       15.6.4 TSQL Examples
Chapter 16: 
 
16.1 Management Portal SQL Facilities
16.2 Executing SQL Statements
16.3 Filtering Schema Contents
       16.3.1 Browse Tab
       16.3.2 Catalog Details Tab
       16.3.3 Open Table
16.4 Actions
16.5 Wizards
Chapter 17: 
 
17.1 Importing Caché SQL
17.2 Code Migration: Importing non-Caché SQL
Chapter 18: 
 
18.1 Defining Triggers
18.2 Types of Triggers
       18.2.1 AFTER Triggers
       18.2.2 Recursive Triggers
18.3 How Trigger Code Works
18.4 Triggers and Object Access
18.5 Triggers and Transactions
18.6 Listing Triggers
Chapter 19: 
 
19.1 Overview
19.2 Defining Stored Procedures
19.3 Using Stored Procedures
       19.3.1 Stored Functions
       19.3.2 Privileges
19.4 Listing Procedures
Chapter 20: 
 
20.1 Stream Fields and SQL
       20.1.1 BLOBs and CLOBs
20.2 Defining Stream Fields Using DDL
       20.2.1 Empty BLOBs
20.3 Stream Field Concurrency Locking
20.4 Using Stream Fields within Caché Methods
20.5 Using Stream Fields from ODBC
20.6 Using Stream Fields from JDBC
Chapter 21: 
 
21.1 Users
21.2 Roles
21.3 Privileges
Chapter 22: 
 
22.1 Architecture of the Caché SQL Gateway
22.2 Creating Gateway Connections for External Sources
22.3 The Link Table Wizard: Linking to a Table or View
22.4 The Link Procedure Wizard: Linking to a Stored Procedure
22.5 Controlling Gateway Connections
22.6 The Data Migration Wizard: Migrating Data from an ODBC Source
 
Appendix A: 
 
A.1 Importing Data from a Text File
A.2 Exporting Data to a Text File