Mimer SQL User's Manual TOC PREV NEXT INDEX

Mimer Developer Site

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
Mimer SQL User's Manual TOC PREV NEXT INDEX