Table of Contents
Introduction >>
1. Introduction
1.1. What is CSQL
1.2. CSQL Components
1.2.1. CSQL Main Memory Database
1.2.2. CSQL Cache
1.2.3. CSQL Replication
1.3. Information In This Manual
1.4. Conventions
1.4.1. Typographic Rule
1.4.2. Syntax Annotation
1.5. Additional Documentation
1.5.1. On-Line Help
1.5.2. Documentation Notes, Release Notes
2. Overview Of CSQL MMDB Cache System
2.1. What Is MMDB AND DRDB
2.2. Advantages Of CSQL MMDB
2.3. CSQL - Open Source Product
2.4. CSQL Web Site
2.5. Basic Features
2.5.1. Main features of CSQL
2.5.2. Standards Compliance
2.5.2.1. SQL 92 Entry Level
2.5.2.2. ODBC Level 2
2.5.2.3. JDBC 3.0
2.6. Feature Overview
2.6.1. ODBC and JDBC Interfaces
2.6.2. Database Connectivity
2.6.3. Caching option for Disk based Databases
2.7. What Is New In CSQL 2.5
2.8. Who Can Use CSQL
2.9. CSQL Selective Information References
2.9.1. Mailing lists
2.9.2. Forums
3. CSQL Installation
3.1. Where To Find CSQL
3.2. OS Platform Support
3.3. Installation Prerequisites
3.4. Directory Layout And Files
3.5. Running Examples
3.6. How To Configure CSQL
3.6.1. Setting up environmental variables (setupenv.ksh)
3.6.1.1. CSQL_INSTALL_ROOT
3.6.1.2. CSQL_CONFIG_FILE
3.6.1.3. LD_LIBRARY_PATH
3.6.1.4. PATH
3.6.1.5. CLASSPATH
3.6.2. Configuration File (csql.conf)
3.6.2.1. Server section variables
3.6.2.2. Client section variables
3.6.2.3. Cache section variables
3.7. Starting And Stopping csqlserver
3.8. Troubleshooting
3.8.1. Errors while running csqlserver
3.8.1.1. csqlserver command not found
3.8.1.2. Unable to create the log file
3.8.2. Errors while running Client
4. Data Types
4.1. Numeric Types
4.1.1. Integer Types
4.1.2. Floating point types
4.2. Charcater Types
4.3. Binary Data Types
4.4. Date/Time Types
4.4.1. Date
4.4.2. Time
4.4.3. Time Stamp
4.5. Default Field To Current DATE/TIME
4.6. Insert Record With Current DATE/TIME
4.7. Update Records With Current DATE/TIME
5. Transaction Control
5.1. Committing Transaction
5.2. Automatic Transaction Commit
5.3. Rolling Back Transaction
6. Getting Started With CSQL
6.1. Client Tool
6.2. CREATE USER
6.3. CHANGE USER PASSWORD
6.4. DROP USER
6.5. CREATE TABLE
6.6. USING CSQL IN BATCH MODE
6.7. Metadata Info
6.8. SHOW TABLES statement
6.9. SHOW USERS statement
6.10. SHOW VARIABLES statement
6.11. Auto Increment Field
6.12 INSERT Statement
6.13 Update
6.14 Delete
6.15 SELECT Statement
6.16 LIMIT and OFFSET
6.17 ORDER BY
6.18 COPY TABLE statement
6.19 COMPACT statement
7. Function And Operators
7.1. Logical Operators
7.2. Comparison Operators
7.3. Arithmetic Operators
7.5. SQL Operators
7.5.1. IN operator
7.5.2. BETWEEN operator
7.5.3. LIKE operator
7.5.4. IS NULL operator
8. Aggregate Functions, Group By and Having Clause
8.1.Aggregate Functions
8.2.GROPUP BY Clause
8.3.HAVING Clause
9. Joins
9.1.Equi Join or Inner Join
9.2.Non Equi Join
9.3.Self Join
9.4.Left Join
10. Integrity Constraint
10.1. Not Null
10.2. Default Clause
10.3. Unique
10.4. Primary Key
10.5. Foreign Key
11. Index
11.1. Hash Index
11.2. Tree Index
11.3. Composite Index
11.4. Unique Index AND Primary Key Index
11.5. Resize Index Bucket Size
12. Database Recovery
12.1. Automatic Recovery
12.2. ARCHIVE/RESTORE
12.2.1. Archive the database
12.2.2. Restore the database
13. Tool Reference
13.1. CSQL
13.2. CATALOG
13.3. CSQLDUMP
Before You Start >>