JDB SQL Reference

Symbols

# (pound sign)

comments in ISQL A-3

comments in JISQL 5-20

% (percent sign)

as pattern matching operator 6-33

; (semicolon)

command terminator in JISQL 5-20

_ (underscore)

as pattern matching operator 6-33

A

Addition operation

in JDB 6-37

Aggregate functions

in JDB 6-4

with GROUP BY clause 6-21

ALL keyword

in JDB 6-49

ANY keyword

in JDB 6-49

Arithmetic operators

in JDB 6-37

ASC keyword

specifying data order 6-42

AVG function

in JDB 6-4

B

BETWEEN predicate

in JDB 6-7, 6-54

C

char (data type)

in JDB 6-15

Column list 3-6

Columns

Database columns 2-3

Commit

transaction in ISQL A-4

transaction in JDB 3-9

Comparison operators

in JDB 6-38

Configuration

JDB 4-6

Connections

to JDB database 4-7

Correlation names

for database tables 3-8

for self-joins

for self-joins 6-31

COUNT function

in JDB 6-4

CREATE DATABASE statement

in JDB 6-9

CREATE TABLE statement

in JDB 6-11

Creating

databases

in JDB 6-9

D

Data

deleting from database

in JDB 6-18

entering into database

in JDB 6-25

grouping data 6-21

matching specified pattern 6-33

modifying

in JDB 6-52

selecting

from multiple tables 6-27

in JDB 6-44

specifying data order 6-42

Data type

in JDB 4-2, 6-15

Database

connecting to

in JDB 4-7

creating

in ISQL A-2

in JDB 6-9

designing 2-7

recreating JDB database A-6

relational 2-1

Database columns

defined 2-3

defining

in JDB 6-11

in JISQL 5-7

naming conventions 2-6

in JDB 4-2

selecting 6-44

Database connections

to JDB database 4-7

Database tables

Tables 2-2

datetime (data type)

in JDB 6-16

DELETE statement

constructing 3-6

in JDB 6-18

DESC keyword

specifying data order 6-42

Division operation

in JDB 6-37

double (data type)

in JDB 6-16

DROP DATABASE statement

in JDB 6-19

DROP TABLE statement

in JDB 6-20

E

Equi-joins 6-27

Error messages

JDB B-1

EXISTS keyword

in JDB 6-48, 6-55

Expressions

in JDB 6-38

F

File

export JDB database to text files A-7

import to JDB database from text files A-7

float (data type)

in JDB 6-15

Foreign keys

defined 2-6

defining using JISQL 5-11

Functions

aggregate functions 6-4

G

GROUP BY clause

in JDB 6-21

H

HAVING clause

in JDB 6-23

I

IN keyword

in JDB 6-48, 6-55

INSERT statement

constructing 3-5

in JDB 6-25

NULL values and 6-35

int (data type)

in JDB 6-15

Interactive SQL

in JDB

ISQL A-2

JISQL 5-1

ISQL

clearing the input buffer A-3

command terminator A-3

committing transactions A-4

connecting to a database A-4

editing statement in A-4

executing a command file A-4

exiting A-4

starting A-2

using interactive SQL utility

in JDB A-2

J

JDB

connecting to database

using ISQL A-2

using JISQL 5-3

creating databases 4-1, 6-9, A-2

using JISQL 5-4

deleting databases 6-19

describing 1-1

describing tables using JISQL 5-16

disconnecting from database using JISQL 5-3

dropping databases using JISQL 5-17

error messages B-1

executing transactions 3-9

isql (interactive SQL) utility A-2

journal files 4-6

keywords C-1

naming conventions 4-1

SQL commands 6-1

SQL syntax summary 6-58

system tables 4-3

unsupported features 1-3

using JISQL 5-1

utilities A-1

jdbroll A-5

JISQL 5-1

command terminator 5-20

connecting to a database 5-3

creating databases 5-4

creating tables 5-5

defining columns 5-7

disconnecting from a database 5-3

displaying database description 5-16

dropping databases 5-17

dropping tables 5-17

editing SQL scripts 5-18

executing operating system commands 5-4

executing SQL scripts 5-22

exiting 5-2

log file 5-22, 5-25

macro commands 5-21

output options 5-22

query results 5-23

running interactive SQL 5-18

script format 5-20

starting 5-1

terminating execution 5-23

Join

database tables 3-7, 6-27

using correlation names 3-8

Journal file

in JDB 4-6

K

Key columns

defining using JISQL 5-8

foreign key

defined 2-6

primary key

defined 2-4

Keywords

in JDB 2-7, C-1

L

LIKE predicate

in JDB 6-33, 6-56

Log file

JISQL 5-25

Logical operators

in JDB 6-39

logon

connecting to JDB database A-4

long (data type)

in JDB 6-15

M

Macro commands

JISQL 5-21

MAX function

in JDB 6-4

Message file

JDB 4-6

MIN function

in JDB 6-4

mksql

creating script for JDB database A-6

Multiple table joins 6-29

Multiplication operation

in JDB 6-37

N

Natural joins 6-28

NOT keyword in JDB

in joins 6-27

NOT BETWEEN 6-7, 6-54

NOT EXISTS 6-48, 6-55

NOT IN 6-48, 6-55

NOT LIKE 6-33, 6-56

NOT NULL 6-35, 6-56

NULL

specifying in JDB 6-35

Null value

and arithmetic operations in JDB 6-37

and COUNT aggregate function 6-4

defined 2-3

specifying in JDB 6-35, 6-41

O

Operating system

executing command

from JISQL 5-4

Operators

in JDB 6-37

ORDER BY clause

in JDB 6-42

P

Primary keys 2-8

defined 2-4

defining using JISQL 5-9

Q

Queries

database 6-44

quit

exiting ISQL A-4

R

Range

search conditions in JDB 6-7

Relational databases 2-1

Restrictions

JDB 1-3

Rollback

transaction in ISQL A-4

transaction in JDB 3-9

Rows

defined 2-4

S

Schema

defined 2-1

Search conditions

in SQL statements 6-54

SELECT statement

construction 3-2

in INSERT statement 6-26

in JDB 6-44

NULL values and 6-35

select list 3-2

Self-joins

in JDB 6-31

SMEDITOR

editing SQL statements 4-6

SOME keyword

in JDB 6-49

SQL

commands

in JDB 6-1

constructing SQL statements 3-1

executing in JISQL 3-10

executing in JPL 3-10

recreating JDB database A-6

syntax summary for JDB 6-58

Subqueries

database 6-48

Subtraction operation

in JDB 6-37

SUM function

in JDB 6-4

Syntax summary

JDB 6-58

system

executing operating system command in ISQL A-4

System tables

in JDB 4-3

T

Tables

creating

in JDB 6-11

in JISQL 5-5

defined 2-2

defining keys

using JISQL 5-8

describing in JISQL 5-16

dropping

in JDB 6-20

using JISQL 5-17

exporting

to text files A-7

importing

from text files A-7

joining multiple 3-7, 6-27

naming conventions 2-6

in JDB 4-2

selecting data 6-44

setting correlation names 3-8

system tables

in JDB 4-3

tbldata

importing/exporting JDB database A-7

Text files

import/export to JDB database A-7

Transaction

defined 3-9

processing for database

JDB 3-9

U

Unique keys

defining using JISQL 5-9

Unsupported features

JDB 1-3

UPDATE statement

constructing 3-5

in JDB 6-52

Utilities

isql A-2

jdbroll A-5

mksql A-6

tbldata A-7

V

videobiz

description of database D-1

diagram 2-8

W

WHERE clause

constructing 3-4

in JDB 6-54

Wildcard characters

in JDB 6-33