docs.intersystems.com
Home  /  Application Development: Core Topics  /  Using InterSystems SQL


Using InterSystems SQL
Contents
[Next] 
InterSystems: The power behind what matters   
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 External Tables
5.7 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 Enterprise Cache Protocol (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.4.1 %Prepare()
       13.4.2 %PrepareClassQuery()
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 Other Ways of Executing SQL
14.2 Invoking the SQL Shell
14.3 Storing and Recalling SQL Statements
       14.3.1 Recall by Number
       14.3.2 Recall by Name
14.4 SQL Shell Parameters
14.5 SQL Metadata and Performance Metrics
14.6 Transact-SQL Support
       14.6.1 Setting DIALECT
       14.6.2 Setting COMMANDPREFIX
       14.6.3 RUN Command
       14.6.4 TSQL Examples
Chapter 15: 
 
15.1 Management Portal SQL Facilities
15.2 Executing SQL Statements
15.3 Filtering Schema Contents
       15.3.1 Browse Tab
       15.3.2 Catalog Details Tab
       15.3.3 Open Table
15.4 Actions
15.5 Wizards
Chapter 16: 
 
16.1 Importing InterSystems SQL
16.2 Code Migration: Importing non-InterSystems SQL
Chapter 17: 
 
17.1 Defining Triggers
17.2 Types of Triggers
       17.2.1 AFTER Triggers
       17.2.2 Recursive Triggers
17.3 How Trigger Code Works
17.4 Triggers and Object Access
17.5 Triggers and Transactions
17.6 Listing Triggers
Chapter 18: 
 
18.1 Overview
18.2 Defining Stored Procedures
18.3 Using Stored Procedures
       18.3.1 Stored Functions
       18.3.2 Privileges
Chapter 19: 
 
19.1 Stream Fields and SQL
       19.1.1 BLOBs and CLOBs
19.2 Defining Stream Fields Using DDL
       19.2.1 Empty BLOBs
19.3 Stream Field Concurrency Locking
19.4 Using Stream Fields within InterSystems IRIS Methods
19.5 Using Stream Fields from ODBC
19.6 Using Stream Fields from JDBC
Chapter 20: 
 
20.1 Users
20.2 Roles
20.3 Privileges
Appendix A: 
 
A.1 Importing Data from a Text File
A.2 Exporting Data to a Text File