www.mimer.com/developer

A - B - C - D - E - F - G - H - I - J - K - L - M - N - O - P - Q - R - S - T - U - V - W - X - Y - Z

Index

---

Symbols

@ 1, 2

A

access control statements 1

GRANT 1

REVOKE 1

access privileges 1, 2

DELETE 1

examples 1

granting 1

INSERT 1

REFERENCES 1

SELECT 1

UPDATE 1

active connection 1

ALL 1

ALTER DATABANK 1

ALTER IDENT 1

ALTER TABLE 1

ANY 1

arithmetic operations 1

AS

for column labels 1

for connection name 1

AVG 1

B

BACKUP 1

back-up protection 1

batch jobs 1

security 1

Batch SQL 1

BETWEEN operator 1

BSQL 1

batch jobs 1, 2

command-line arguments 1

commands 1

errors in 1

host variables 1

logging in 1

running 1

running in OpenVMS 1

running in Windows 1

syntax descriptions 1

Unix 1

Unix command line 1

variables 1

BSQL commands

CLOSE 1

DESCRIBE 1

DESCRIBE options 1

EXIT 1

LIST 1

LIST options 1

LOAD 1

LOG 1

READ INPUT 1

SET ECHO 1

SET LINECOUNT 1

SET LINESPACE 1

SET LINEWIDTH 1

SET LOG 1

SET MESSAGE 1

SET OUTPUT 1

SET PAGELENGTH 1

SET PAGEWIDTH 1

SHOW SETTINGS 1

UNLOAD 1

WHENEVER 1

C

CASCADE 1, 2

CASE 1

CAST 1

changing connections 1

changing passwords 1

CHAR_LENGTH 1

character set 1

character string comparison 1

CHECK

in domain 1

check

conditions 1

option in views 1

check conditions

in tables 1

check option in views 1

client/server 1

column labels 1

column names in UNION 1

comments 1

committing transactions 1

comparison 1

computed values 1

concurrency control 1

CONNECT 1

connection statements 1

CONNECT 1

DISCONNECT 1

ENTER 1

LEAVE 1

SET CONNECTION 1

constraints

referential 1

unique 1, 2

correlation names 1

COUNT 1

creating

databanks 1

domains 1

modules 1

procedures 1

secondary indexes 1

synonyms 1

tables 1

triggers 1

views 1

views on views 1

cross product 1

D

data definition statements 1

ALTER 1

COMMENT 1

CREATE 1

DROP 1

data dictionary 1

databanks 1

domains 1

functions 1

idents 1

indexes 1

modules 1

privileges 1

procedures 1

schemas 1

sequences 1

shadows 1

synonyms 1

tables 1

triggers 1

views 1

data integrity 1

data manipulation 1

data manipulation statements 1

CALL 1

DELETE 1

INSERT 1

SELECT 1

SET 1

UPDATE 1

DATABANK 1

databank shadows 1

databanks 1

altering 1

creating 1

data dictionary 1

dropping 1

system 1

user 1

database 1

definition statements 1

design 1

object names 1

objects 1

private objects 1

system objects 1

database administration statements 1

ALTER DATABANK 1

CREATE BACKUP 1

CREATE INCREMENTAL BACKUP 1

RESTORE 1

SET DATABANK 1

SET DATABASE 1

SET SHADOW 1

UPDATE STATISTICS 1

datetime

arithmetic 1

functions 1

default values in domains 1

DELETE 1, 2

delimiting complex statements with @ 1

DISCONNECT 1

DISTINCT 1

in set functions 1

domains 1

check clause 1

creating 1

data dictionary 1

default values 1

dropping 1

dropping objects 1

duplicate values 1

E

ENTER 1

error handling 1

errors

examples 1

illegal BSQL commands 1

messages 1

semantic 1

syntax 1

ESCAPE in LIKE conditions 1

example database 1

CREATE DATABANK 1

CREATE DOMAIN 1

CREATE Procedures 1

CREATE statements 1

CREATE TABLE 1

CREATE Trigger 1

CREATE View 1

installing 1

table contents 1

table descriptions 1

tables 1

EXECUTE 1

EXISTS

condition 1

NULL values 1

EXTRACT 1

F

FORALL 1

foreign keys 1, 2

functions 1

data dictionary 1

G

grant option 1, 2

granting privileges 1

GROUP BY 1

group idents 1

H

HAVING 1

host identifier 1

host variables 1

scope 1

SQL 1

using 1

I

IDENT 1

idents 1, 2

altering 1

data dictionary 1

dropping 1

group 1

names 1

OS_USER 1

program 1

structure 1

user 1

IN condition 1

indexes 1

data dictionary 1

indicator variable 1

indicator variables

including 1

INSERT 1, 2

inserting NULL values 1

inserting with a subselect 1

inserting with a values list 1

IS NULL 1

isolation levels in transactions 1

J

join

a table with itself 1

condition 1

views 1

joins

natural 1

outer 1

simple 1

K

keys 1

foreign 1

primary 1

L

LEAVE 1

LIKE 1

LOG databank option 1

LOGDB 1

logging 1

options 1

logical operators 1

LOWER 1

M

MAX 1

MEMBER 1

merging with UNION 1

messages 1

MIN 1

modules 1

creating 1

data dictionary 1

N

natural joins 1

nested selects 1

NULL databank option 1

NULL values

in EXISTS etc. 1

in SELECT 1

in set functions 1

in variables 1

inserting 1

treated as equal by distinct 1

O

object privileges 1, 2, 3

examples 1

EXECUTE 1

granting 1

MEMBER 1

TABLE 1

USAGE 1

optimization 1

optimizing transactions

READ ONLY and READ WRITE 1

ORDER BY 1

in subselects 1

OS_USER ident 1

outer joins 1

outer references 1

P

passwords 1

pattern conditions 1

POSITION 1

predicates

quantified 1

primary key 1, 2

private objects 1

privileges 1, 2

data dictionary 1

granting 1

granting and revoking 1

revoking 1

CASCADE 1

RESTRICT 1

system utilities 1

procedures 1

creating 1

data dictionary 1

procedures and modules

protection against CASCADE effects 1

program idents 1, 2

R

read-set 1

REFERENCES 1, 2

referential integrity 1, 2

RESTRICT 1, 2

result table 1

retrieving data

from multiple tables 1

from single tables 1

revoking privileges 1

routines 1

S

scalar functions 1

using 1

SCHEMA 1

schemas 1, 2

data dictionary 1

searching for NULL 1

secondary indexes 1

creating 1

SELECT 1

computed values 1

creating views 1

DISTINCT 1

EXISTS 1

GROUP BY 1

HAVING 1

NULL values 1

ordering the result 1

quantified predicate 1

simple form 1

UNION 1

WHERE 1

selecting groups 1

selection process 1

sequences 1

data dictionary 1

SET

CONNECTION 1

set conditions 1

set functions 1

SET SESSION 1

SET TRANSACTION 1

SHADOW 1

shadowing 1

shadows

data dictionary 1

simple joins 1

SOME 1

source table 1

SQL statements 1

access control 1

connection 1

data definition 1

data manipulation 1

database administration 1

transaction control 1

STATISTICS 1

stored procedures 1

string concatenation 1

subselects 1

in INSERT 1

SUBSTRING 1

SUM 1

synonyms 1

creating 1

data dictionary 1

syntax errors 1

SYSADM 1

SYSADM privileges 1

SYSDB 1

system databanks 1

system objects 1

system privileges 1, 2

BACKUP 1

DATABANK 1

examples 1

IDENT 1

SHADOW 1

STATISTICS 1

T

TABLE 1

tables 1

altering 1

base and views 1

check conditions 1

column definitions 1

creating 1

data dictionary 1

dropping 1

TRANS databank option 1

transaction

consistency 1

control options 1

control statements 1

diagnostics size 1

logging 1

options 1

optimization 1

phases 1

transaction control statements 1

COMMIT 1

ROLLBACK 1

SET SESSION 1

SET TRANSACTION 1

START 1

TRANSDB 1

trigger

creating 1

triggers

data dictionary 1

TRIM 1

U

UNION 1

unique constraints 1

updatable views 1

UPDATE 1, 2

UPPER 1

USAGE 1

user databanks 1

user idents 1

V

variables 1

views 1

check options 1, 2

creating 1

creating on 1

data dictionary 1

join 1

restriction 1

updatable 1

W

WHERE condition 1

wildcard characters 1

write-set 1

Upright Database Technology AB Voice: +46 18 780 92 00 Fax: +46 18 780 92 40 dbtechnology@upright.se