Contents:

About This Document

1. Introduction to JDB

• Using JDB
• JDB Executables and Utilities
• Unsupported Features
• See Also

2. Introduction to Databases

• Structure of a Relational Database
• Designing Your Database

3. Introduction to SQL

• SQL Statements
• SQL Concepts
• Executing SQL
• See Also

4. Database Elements

• Naming Conventions
• Data Types
• System Tables
• Journal Files
• Configuration

5. Using JISQL

• Starting JISQL
• Creating a New Database
• Creating Database Tables
• Defining Keys for a Database Table
• Maintaining a Database
• Running SQL Interactively

6. SQL Reference

• Reference Organization
• Aggregate Functions
• BETWEEN Predicate
• CREATE DATABASE Statement
• CREATE TABLE Statement
• Data Types
• DELETE Statement
• DROP DATABASE Statement
• DROP TABLE Statement
• GROUP BY Clause
• HAVING Clause
• INSERT Statement
• Joins
• LIKE Predicate
• Null Values
• Operators
• ORDER BY Clause
• SELECT Statement
• Subqueries
• UPDATE Statement
• WHERE Clause
• SQL Syntax Summary

A. JDB Utilities

• isql
• jdbroll
• mksql
• tbldata

B. JDB-Specific Error Messages

• Error Message Listing

C. Keywords in JDB

D. Videobiz Database

• Videobiz Schema

Index