MasterMobileNetIX.html

http://developer.mimer.com

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

Symbols

@ 1, 2

triggers 1

A

aborting transactions 1
ABS 1
access

privileges 1, 2, 3, 4, 5

DELETE 1
INSERT 1
REFERENCES 1
SELECT 1
UPDATE 1

access control statements 1, 2

GRANT 1
REVOKE 1

access privileges 1

DELETE 1, 2
examples 1
granting 1
INSERT 1, 2
REFERENCES 1, 2
revoking 1
SELECT 1, 2
UPDATE 1, 2

access rights

for cursors 1

access-clause for procedures 1
accessing data 1
active connection 1, 2
ALL 1, 2, 3

in SELECT clause 1
predicate 1

ALLOCATE CURSOR 1
ALLOCATE DESCRIPTOR 1
ALTER DATABANK 1, 2

ADD ... PAGES 1
INTO 1
TO

LOG 1
NULL 1
TRANS 1

ALTER DATABANK RESORE

filename-string 1

ALTER DATABANK RESTORE 1

LOG 1

ALTER IDENT 1, 2
ALTER SHADOW 1
ALTER TABLE 1, 2
ANSI/ISO 1
ANY 1, 2
APIs

embedded SQL 1
JDBC 1
ODBC 1

arithmetic operations 1
arithmetical operators 1, 2
arrays 1
AS

for column labels 1
for connection name 1

ASCII_CHAR 1
ASCII_CODE 1
assigning values 1

standard compliance 1, 2

assignment

SET 1

assignments 1

string 1

authorization

database statistics 1
DBC 1
DBOPEN 1

AVG 1, 2

B

BACKUP 1

privilege 1, 2

backup

databank 1

backup and restore 1

SQL statements 1

back-up protection 1
backups of databanks 1
backward compatibility 1
balanced I/O 1
basic predicate 1

subselect 1

batch jobs 1

security 1

Batch SQL 1
BEGIN DECLARE SECTION 1, 2
BETWEEN 1
BETWEEN operator 1
binary operators 1
BIT_LENGTH 1
BSQL 1, 2, 3

batch jobs 1
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 1

CLOSE 1
DESCRIBE 1
DESCRIBE options 1
EXIT 1
LIST 1
LIST options 1
LOG 1
READ INPUT 1
SET ECHO 1
SET LINECOUNT 1
SET LINESPACE 1
SET LINEWIDTH 1
SET LOG 1
SET MAX_BINARY_LENGTH 1
SET MAX_CHARACTER_LENGTH 1
SET MESSAGE 1
SET OUTPUT 1
SET PAGELENGTH 1
SET PAGEWIDTH 1
SHOW SETTINGS 1
TRANSACTIONS 1
WHENEVER 1

bufferpool 1

report 1

C

C (programming language)

preprocessor output 1

C/C++ 1

comments 1
data types 1

value assignments 1

host variables 1

declaring 1

line continuation 1
null terminated strings 1
quotation marks 1
special characters 1
statement delimiters 1
statement format 1
white-space 1

CALL 1
CALL statement 1
calling procedures 1, 2
CASCADE 1, 2, 3, 4, 5, 6
cascade 1

access privileges 1
effects with drop and revoke 1

CASE 1, 2

rules 1

CASE expression 1

is COALESCE 1
is NULLIF 1
rules 1
short forms 1

CAST 1, 2
CAST specification 1

example 1
rules 1
syntax 1

CATALOG_NAME 1
changing connections 1
changing databank file location 1
changing password 1
changing passwords 1
changing shadow to master databank 1
CHAR(n) 1
CHAR_LENGTH 1, 2
character set 1, 2
character string 1
character string comparison 1
CHARACTER(n) 1
CHARACTER_SET_ CATALOG 1
CHARACTER_SET_ NAME 1
CHARACTER_SET_ SCHEMA 1
character-string-literal 1
CHECK 1, 2

in domain 1, 2

check

conditions 1
option in views 1

check conditions 1

in tables 1

CHECK OPTION

in view definition 1

check option in views 1
check options 1
client/server 1
CLOB

maximum length 1, 2

CLOSE 1
closing a cursor 1
COALESCE 1
COBOL 1

comments 1
data types 1
host variables 1
line continuation 1
preprocessor output 1
statement delimiters 1

COLLATE 1
collation 1, 2
COLLATION_CATALOG 1
COLLATION_NAME 1
COLLATION_SCHEMA 1
collations 1

altering 1
comparison operators 1
concatenation operator 1
CREATE DOMAIN 1
CREATE INDEX 1
CREATE/ALTER TABLE 1
DISTINCT 1
dropping 1
GROUP BY 1
IN and BETWEEN 1
INFORMATION_SCHEMA 1
ORDER BY 1
precedence 1
scalar string functions 1
UNION 1
using 1
using - examples 1

column

adding 1
altering 1
dropping 1

column definition 1
column labels 1
column names

in UNION queries 1
in views 1

column names in UNION 1
COLUMN_NAME 1
COMMAND_FUNCTION 1, 2
command-line arguments

MIMCONTROL 1
MIMINFO 1
SDBGEN 1
SDBGEN - upgrading 1

COMMENT 1
comments 1, 2, 3

changing 1
dropping 1
in COBOL 1
in FORTRAN 1
in routines 1

COMMIT 1, 2
committing transactions 1
comparison 1
comparison operators 1
comparisons 1

truth tables 1

compiler 1
computed values 1
concatenation 1
concurrency control 1, 2
condition names

declaring 1

CONDITION_NUMBER 1
conditional execution

CASE 1
IF 1

CONFORMANCE 1
CONNECT 1, 2

backward compatibility syntax 1

connecting 1
connection name 1
connection statements 1, 2

CONNECT 1
DISCONNECT 1
ENTER 1
LEAVE 1
SET CONNECTION 1

CONNECTION_NAME 1
connections

cursors 1

CONSTRAINT_CATALOG 1
CONSTRAINT_SCHEMA 1
constraints

referential 1
unique 1, 2

CONTINUE 1
correlation names 1, 2
COUNT 1, 2
CREATE

BACKUP 1
DATABANK 1
DOMAIN 1
FUNCTION 1
IDENT 1
INDEX 1
MODULE 1
PROCEDURE 1
SCHEMA 1
SEQUENCE 1
SHADOW 1
SYNONYM 1
TABLE 1
TRIGGER 1
VIEW 1

CREATE STATEMENT 1
creating

comments 1
databanks 1, 2
domain 1
domains 1
function 1
ident 1
module 1
modules 1
procedure 1
procedures 1
schema 1
secondary index 1
secondary indexes 1
sequence 1
shadow databank 1
synonym 1
synonyms 1
table 1
tables 1
trigger 1
triggers 1
view 1
views 1
views on views 1

cross product 1
current row 1
CURRENT_DATE 1
CURRENT_PROGRAM 1
cursor

closing 1

cursor stack 1, 2, 3
CURSOR_NAME 1
cursor-independent data manipulation 1
cursors 1, 2

access rights 1, 2
and program idents 1
closing 1
declaring 1, 2
deleting current row 1
evaluating declaration 1
evaluating SELECT statement 1
extended dynamic 1
for join conditions 1
for UPDATE and DELETE 1
in dynamic SQL 1
in multiple connections 1
opening 1, 2
position after delete 1
position in result set 1, 2
positioning 1
positioning in result set 1
REOPENABLE 1, 2
resource allocation 1
retrieving data 1
SCROLL 1, 2
stacking 1
transactions 1
updatable 1
updating and deleting with 1
updating data 1

D

data

binary 1
description headers 1
errors 1
files 1
loading 1
numerical 1

data definition statements 1, 2

ALTER 1
COMMENT 1
CREATE 1
DROP 1

data dictionary 1, 2, 3

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, 2
triggers 1
views 1

data integrity 1, 2, 3

check conditions 1
check options 1
domains 1
foreign keys 1

data manipulation 1
data manipulation statements 1

CALL 1
DELETE 1
INSERT 1
SELECT 1
SET 1
UPDATE 1

data protection 1

levels 1

data types

abbreviations 1
BINARY VARYING(n) or VARBINARY(n) 1
BINARY(n) 1
C/C++ 1
CHAR(n) 1
CHARACTER VARYING(n) or VARCHAR(n) 1
CHARACTER(n) 1, 2
compatibility 1
compatibility in FETCH statements 1
conversion 1, 2, 3, 4
DATE TIME TIMESTAMP 1
DOUBLE PRECISION 1
in COBOL 1
in FORTRAN 1
INTERVAL 1
NCHAR 1
NCHAR VARYING 1
parameter markers 1
ROW 1
standard compliance 1

DATABANK 1

privilege 1

databank 1, 2

access errors 1
altering 1
backup 1
creating 1
dropping 1
file location 1, 2
name 1, 2
offline 1
restoring 1
shadow 1
shadows offline 1
shadows online 1
system 1
user 1

databank check. See DBC 1
DATABANK privilege 1
databank shadows 1
databanks 1, 2

allocating disk space 1
altering 1
backup 1
changing location 1
creating 1
data dictionary 1
data security 1
disk I/O 1
dropping 1
file access 1
file deletion 1
initial size 1
locating files 1
online 1
options 1
organizing 1
recreating 1
restoring from backup 1
system 1, 2

LOGDB 1
SQLDB 1
SYSDB 1
TRANSDB 1

user 1, 2

database 1, 2

accessing 1
administration 1
connecting 1
connecting to 1
creating example 1
data dictionary 1
default (node-specific) 1
defining user specific 1
definition statements 1
design 1
environment 1
ident and data structure 1
listing connected users 1
local 1
object names 1
objects 1, 2
offline 1
online 1
optimizing performance 1
private objects 1, 2
privileges 1
remote 1
security 1
selecting 1
single-user mode 1
statistics 1
SYSADM 1
system objects 1, 2
troubleshooting connect failures 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

database server 1

bufferpool 1
client-server interface 1
communication buffers 1
controlling 1
error messages 1
managing 1
memory requirements 1
MIMCONTROL 1
MIMINFO 1
performance 1
SQLPOOL 1
system information 1
system requirements 1
threads 1

DATE 1
datetime

arithmetic 1
functions 1

datetime and interval comparisons 1
datetime assignments 1
DATETIME data types 1
Datetime literals 1
Datetime pseudo literals 1
DATETIME_INTERVAL _CODE 1
DATETIME_INTERVAL _PRECISION 1
DAYOFWEEK 1
DAYOFYEAR 1
DAY-TIME 1
DBC 1

command-line arguments 1
error messages 1

bitmap errors 1
root page errors 1
sequential structure errors 1
table structure errors 1

for LOGDB, TRANSDB and SQLDB 1

end page 1
no. of pages read 1
no. of records read 1
page size 1
start page 1
status of table 1
tabid 1
type of table 1

result file 1
syntax 1
table information 1

data page size 1
index page size 1
keylen 1
levels 1
number of data pages 1
number of index pages 1
reached no of records 1
reclen 1
required/allocated data pages 1
startp 1
status of table 1
tabid 1
type of table 1

DBOPEN 1

authorization 1
background threads 1
command-line arguments 1
error status 1
functions 1
multi-user mode 1
output example 1
syntax 1

DDL 1
deadlock 1
DEALLOCATE

DESCRIPTOR 1
PREPARE 1

deallocating cursor resources 1
debugging 1
decimal literals 1
declaration of SQLSTATE 1
DECLARE

CONDITION 1
CURSOR 1
HANDLER 1
SECTION 1
VARIABLE 1

DECLARE SECTION 1
declaring

condition names 1
cursors 1
host variables 1
routine variables 1

declaring host variables 1
declaring procedure variables 1
DEFAULT

in column definition 1
in domain 1

DEFAULT section 1
default transaction mode settings 1
default values 1
default values in domains 1
DELETE 1, 2, 3, 4, 5

CURRENT 1
privilege 1
privileges 1

delimiting complex statements with @ 1
deprecated features 1, 2

parameter markers 1
SET TRANSACTION CHANGES 1
SQLCODE 1, 2
SQLDA 1
VARCHAR(size) 1

DESCRIBE

DATABANK 1
DOMAIN 1
FUNCTION 1
IDENT 1
INDEX 1
MODULE 1
PROCEDURE 1
SCHEMA 1
SEQUENCE 1
SHADOW 1
SYNONYM 1
TABLE 1
TRIGGER 1
VIEW 1

DESCRIBE INPUT 1
DESCRIBE SELECT LIST 1
DESCRIBE USER VARIABLES 1
descriptor area 1

see SQLDA 1

destroy allocated cursor 1
destroy prepared statement 1
diagnostics area 1, 2
DISCONNECT 1, 2
disconnecting 1
DISTINCT 1, 2

in set functions 1

domain 1

creating 1
data integrity 1
dropping 1

domains 1, 2

check clause 1
creating 1
data dictionary 1
default value 1
default values 1
dropping 1

dormant cursors 1
DROP 1, 2
drop

collation 1

drop behavior 1
drop log 1
dropping objects 1
duplicate values 1
dynamic SQL 1, 2

cursors 1
descriptor area 1
example framework 1
executing statements 1
input variables 1
object form of statements 1
output variables 1
parameter markers 1
preparing statements 1
source form of statements 1
SQL statements 1
statement source form 1
statements 1, 2

ALLOCATE CURSOR 1
ALLOCATE DESCRIPTOR 1
CLOSE 1
DEALLOCATE DESCRIPTOR 1
DEALLOCATE PREPARE 1
DESCRIBE 1
EXECUTE 1
EXECUTE IMMEDIATE 1
FETCH 1
GET DESCRIPTOR 1
OPEN 1
PREPARE 1
SET DESCRIPTOR 1
submitting 1

dynamic SQL statements 1

executing 1, 2
opening cursors 1
preparing 1
source form 1

DYNAMIC_FUNCTION 1

E

Embedded SQL

ESQL 1
host languages 1
program structure 1
scope 1
statements 1

embedded SQL control statements 1
END DECLARE SECTION 1, 2
ENTER 1, 2
entity integrity 1
environment variables 1
error

codes 1
handling 1

error handling 1

in transactions 1

error messages

DBC 1

errors

examples 1
illegal BSQL commands 1
messages 1
semantic 1
syntax 1

escape

characters 1
clause 1

ESCAPE in LIKE conditions 1
ESQL 1
evaluating cursor declaration 1
exception

conditions 1
handlers

declaring 1

exception conditions 1
exception handlers 1

continue 1
exit 1
undo 1

exception-info 1
EXEC SQL 1
EXECUTE 1, 2, 3

on routine 1
privileges 1

EXECUTE IMMEDIATE 1
EXECUTE privilege

on procedure 1
on program ident 1

EXECUTE STATEMENT 1
executing statements

sample program 1

EXISTS 1

condition 1
NULL values 1

expression

CASE 1

expressions 1

binary operators 1
evaluating arithmetical 1
evaluating string 1
in SELECT 1
operands 1
precision and scale 1
standard compliance 1
syntax 1
unary operators 1

extended cursor

allocate 1
DELETE CURRENT 1
UPDATE CURRENT 1

EXTRACT 1, 2

F

FETCH 1, 2, 3

scrollable cursor 1

file extension

shadow databank 1

file location

databank 1, 2

floating point literals 1
FOR UPDATE OF 1
FORALL 1
foreign keys 1, 2

data integrity 1

FORTRAN 1

comments 1
host variables 1
line continuation 1
preprocessor output 1
statement delimiters 1
statement margins 1
statement numbers 1

functions 1, 2, 3, 4, 5

data dictionary 1
datetime pseudo literals 1

CURRENT_DATE 1
LOCALTIME 1
LOCALTIMESTAMP 1

invoking 1
scalar functions 1

standard compliance 1

scalar interval functions 1

ABS 1

scalar numeric functions 1

ASCII_CODE 1
BIT_LENGTH 1
CHAR_LENGTH 1
CURRENT_VALUE 1
DAYOFWEEK 1
DAYOFYEAR 1
EXTRACT 1
IRAND 1
MOD 1
NEXT_VALUE 1
OCTET_LENGTH 1
POSITION 1
ROUND 1
SIGN 1
TRUNCATE 1
WEEK 1

scalar string functions 1

ASCII_CHAR 1
CURRENT_PROGRAM 1
LOWER 1
PASTE 1
REPEAT 1
REPLACE 1
SOUNDEX 1
SUBSTRING 1
TAIL 1
TRIM 1
UPPER 1

set functions 1

ALL 1
AVG 1
COUNT 1
DISTINCT 1
eliminating duplicate values 1
empty operand set 1
evaluating 1
examples 1
MAX 1
MIN 1
NULL 1
operational mode 1
precision and scale 1
restrictions 1
results 1
standard compliance 1
SUM 1
syntax 1

SQL statements 1
string 'pseudo literals'

CURRENT_USER 1
SESSION_USER 1
USER 1

string pseudo literals 1
user-defined 1

G

general exception handlers 1
GET DESCRIPTOR 1
GET DIAGNOSTICS 1, 2

COMMAND_FUNCTION 1
DYNAMIC_FUNCTION 1
exception-info 1

ARAMETER_NAME 1
CATALOG_NAME 1
CLASS_ORIGIN 1
COLUMN_NAME 1
CONDITION_IDENTIFIER 1
CONDITION_NUMBER 1
CONNECTION_NAME 1
CONSTRAINT_CATALOG 1
CONSTRAINT_NAME 1
CONSTRAINT_SCHEMA 1
CURSOR_NAME 1
MESSAGE_LENGTH 1
MESSAGE_OCTET _LENGTH 1
MESSAGE_TEXT 1
NATIVE_ERROR 1
RETURNED_SQLSTATE 1
ROUTINE_CATALOG 1
ROUTINE_NAME 1
ROUTINE_SCHEMA 1
SCHEMA_NAME 1
SERVER_NAME 1
SPECIFIC_NAME 1
SUBCLASS_ORIGIN 1
TABLE_NAME 1
TRIGGER_CATALOG 1
TRIGGER_NAME 1
TRIGGER_SCHEMA 1

ROW_COUNT 1
statement-information 1

COMMAND_FUNCTION 1
DYNAMIC_FUNCTION 1
MORE 1
NUMBER 1
ROW_COUNT 1
TRANSACTION_ACTIVE 1

GOTO 1
GRANT OBJECT PRIVILEGE 1
GRANT OPTION 1, 2, 3
grant option 1, 2
GRANT SYSTEM PRIVILEGE 1
granting privileges 1
GROUP BY 1, 2
GROUP ident 1
group ident 1, 2
GROUP idents 1
group idents 1
group membership 1

H

handlers

declaring 1

HAVING 1, 2
host identifier 1
host identifiers 1
host language

included code 1

host languages 1

C/C++ 1
COBOL 1
FORTRAN 1

host variable declarations 1
host variables 1, 2, 3

arrays 1
declaration 1
declarations 1
declaring 1
in COBOL 1
in cursor declarations 1
in FORTRAN 1
in SQL statements 1
names 1
scope 1
SQL 1
using 1

I

IDENT 1

privilege 1, 2

ident 1, 2, 3

access and authority 1
creating 1
disconnecting from a database 1
dropping 1
GROUP 1
group 1, 2
group membership 1
OS_USER 1, 2, 3
PROGRAM 1
program 1, 2
structuring guidelines 1
SYSADM 1
USER 1
user 1, 2

identifiers

host 1
standard compliance 1

idents 1, 2, 3

altering 1
data dictionary 1
dropping 1
GROUP 1
group 1
names 1
OS_USER 1, 2
PROGRAM 1
program 1
structure 1
USER 1
user 1

IF 1
implicit connection 1
IN condition 1
IN predicate 1
INCLUDE SQLCA 1
included code

host language 1

index 1
indexes 1, 2

data dictionary 1

indexing

automatic 1

indicator variable 1
indicator variables 1, 2

including 1

INNER JOINs 1
INSERT 1, 2, 3, 4, 5

privilege 1
privileges 1

inserting NULL values 1
inserting with a subselect 1
inserting with a values list 1
integer literals 1
integrity

domains 1
foreign key 1
in view definitions 1
primary key 1
within tables 1

intermediate result sets 1
internal Mimer SQL return codes 1
INTERVAL 1

literals 1
qualifiers 1

INTERVAL data types 1
invoking functions 1
invoking procedures 1
IRAND 1
IS NULL 1
ISO/IEC 9075 1
isolation levels 1
isolation levels in transactions 1
item descriptor area 1
ITERATE 1, 2
iteration 1

LOOP statement 1
REPEAT statement 1
skip 1
WHILE statement 1

iterative execution

LOOP 1
REPEAT 1
WHILE 1

J

JDBC 1, 2, 3

batch updates 1
callableStatement objects 1
connecting 1
cursors

positioning 1

driver 1

property-list 1
versions 1

error handling 1
executing 1
JDBC 2 1
Jtrace driver 1
loading 1
performance 1
preparedStatement objects 1
result sets 1

capabilities 1
scrolling 1

statement objects 1
tracing 1
transactions 1

auto-commit 1
manual-commit 1

updating data 1
URL syntax 1

JOIN

FULL OUTER 1
INNER 1
LEFT OUTER 1
NATURAL 1
ON 1
OUTER 1
RIGHT OUTER 1
standard compliance 1
USING 1

join

a table with itself 1
condition 1
views 1

join retrievals

using cursors 1

joined tables 1
joins 1

natural 1
outer 1
simple 1

K

keys 1

foreign 1
primary 1

keywords

in syntax diagrams 1

L

labels in SELECT clause 1
LEAVE 1, 2, 3

(program ident) 1

LEAVE RETAIN 1
LENGTH 1
license key 1
LIKE 1, 2

escape characters 1
meta-characters 1
wildcards 1

limits 1, 2
line continuation

in COBOL 1
in FORTRAN 1

LIST

DATABANK 1
DOMAINS 1
FUNCTIONS 1
IDENTS 1
INDEXES 1
MODULES 1
OBJECTS 1
PROCEDURES 1
SCHEMATA 1
SEQUENCES 1
SHADOW 1
SYNONYMS 1
TABLES 1
TRIGGER 1
VIEWS 1

literals 1

standard compliance 1

LOAD 1

AS 1
examples 1
files 1
LOG 1
START AT 1
syntax 1
WITH SHARED ACCESS 1

LOBs 1
LOCAL section 1
LOCALTIME 1
LOCALTIMESTAMP 1
locating databank files 1
LOG databank option 1, 2
LOG option 1
LOGDB 1, 2

information contained in 1
initial creation 1

logging 1

options 1

logical operators 1
LOOP 1
LOOP statement 1
LOWER 1, 2

M

MASTER 1
MAX 1, 2
MEMBER 1, 2

privileges 1

MEMBER privilege 1
merging with UNION 1
MESSAGE_LENGTH 1
MESSAGE_OCTET _LENGTH 1
MESSAGE_TEXT 1
messages 1
meta-characters 1
MIMCONTROL 1

command-line arguments 1
syntax 1

MIMDUMP 1
Mimer SQL 1

basic concepts 1
database objects 1
publications 1, 2

Mimer SQL license key 1
Mimer SQL system databanks 1

generating 1

MIMER_MODE variable 1
MIMINFO 1

bufferpool report 1
command-line arguments 1
performance report 1, 2

background threads 1
bufferpool report 1
databank statistics 1
general statistics 1
page statistics 1
table statistics 1
transaction statistics 1

SQLPOOL report 1, 2
syntax 1
users list 1, 2
using 1

MIMLICENSE

syntax 1

MIMLOAD 1, 2

command-line arguments 1
examples 1
exit codes 1
syntax 1

MIMSERV 1
mimtcp 1, 2, 3
MIN 1, 2
minus sign

in COBOL variable names 1

MOD 1
modules 1, 2, 3, 4

creating 1, 2
data dictionary 1

MORE 1
MULTIDEFS

mimtcp 1

MULTIDEFS file 1
multiple connections 1

N

NAME 1
national character

data 1
NCHAR 1
strings 1

national-character-string-literal 1
NATIVE_ERROR 1
NATURAL JOIN 1
natural joins 1
NCHAR 1
nested selects 1
NEXT_VALUE 1
NOT EXISTS 1
NOT FOUND 1
NULL 1, 2, 3

in comparisons 1
in expressions 1
in host variables 1
in set functions 1
in UNION queries 1
indicator variables 1
predicate 1
transaction control option 1

NULL databank option 1, 2
NULL values

in EXISTS etc. 1
in SELECT 1
in set functions 1
in variables 1
inserting 1
treated as equal by distinct 1

NULLABLE 1
NULLIF 1
NUMBER 1
numerical

assignments 1
comparisons 1
data

precision and scale 1

literals 1
strings 1

O

object

privileges 1

EXECUTE 1
MEMBER 1
TABLE 1
USAGE 1

object privileges 1, 2, 3, 4, 5

examples 1
EXECUTE 1
granting 1
MEMBER 1
revoking 1
TABLE 1
USAGE 1

OCC 1
OCTET_LENGTH 1, 2
ODBC 1, 2, 3

connecting 1
declarations 1
disconnecting 1
driver 1
error handling 1
executing 1
file data source 1
initializing 1
interaction 1
operating systems 1
prepared execution 1
stored procedure 1
transaction processing 1

OPEN 1, 2
operand 1
operands 1
operators 1, 2

alternative forms 1
standard compliance 1, 2

optimistic concurrency control 1, 2
optimization 1
optimizing transactions

READ ONLY and READ WRITE 1

ORDER BY 1, 2

in subselects 1

orientation specification 1
OS_USER ident 1, 2, 3, 4, 5
OUTER JOINs 1
outer joins 1
outer references 1, 2
overflow

error 1
in expressions 1

P

padding

string values 1
with blanks in LIKE predicate 1

parameter markers 1

data types 1
in dynamic SQL statements 1
in SELECT statements 1

PARAMETER_MODE 1
PARAMETER_NAME 1
PARAMETER_ORDINAL_POSITION 1
PARAMETER_SPECIFIC_CATALOG 1
PARAMETER_SPECIFIC_NAME 1
parameters

in syntax diagrams 1

Parts explosion 1
parts explosion problem 1
password 1
passwords 1
PASTE 1
pattern conditions 1
performance

database server 1

persistent stored modules - See stored procedures 1
platforms 1
POSITION 1, 2
precedence

search conditions 1

PRECISION 1
precision 1
predicates 1, 2

ALL 1
ANY or SOME 1
basic 1
EXISTS 1
IN 1
LIKE 1
NULL 1
quantified 1, 2
standard compliance 1, 2
syntax 1

PREPARE 1
preprocessing 1

WHENEVER statements 1

preprocessor output

in C 1
in COBOL 1
in FORTRAN 1

PRIMARY KEY 1
primary key 1, 2
primary keys 1

indexes 1

private objects 1
Privilege

system

databank 1
ident 1
schema 1
shadow 1
statistics 1

Privileges 1
privileges 1, 2, 3

about 1
access 1, 2, 3

ALL 1
delete 1
insert 1
references 1
select 1
update 1

ALTER 1
COMMENT 1
data dictionary 1
DROP 1
GRANT OPTION 1
granting 1

access privileges 1
object privileges 1
system privileges 1

granting and revoking 1
object 1, 2, 3

execute 1
member 1
table 1
usage on domain 1

revoking 1

access privileges 1
CASCADE 1
object privileges 1
RESTRICT 1
system privileges 1

revoking - cascade effects 1
system 1, 2, 3, 4

BACKUP 1
backup 1
DATABANK 1
IDENT 1
SCHEMA 1
SHADOW 1

system utilities 1

procedures 1, 2, 3, 4

access-clause 1, 2, 3
calling 1
creating 1, 2
data dictionary 1
invoking 1
leaving 1
returning result set data 1
returning result sets 1
SQL statements 1
variables 1

value assignment 1

procedures and modules

protection against CASCADE effects 1

PRODUCT 1
program construction errors 1
PROGRAM ident 1
program ident 1, 2
PROGRAM idents 1, 2
program idents 1, 2

EXECUTE privilege 1
leaving 1
retaining resources 1

program structure 1
PSM - See stored procedures 1
PSM Debugger 1

choosing a routine 1
executing a routine 1
input parameters 1
logging in 1
requirements 1
setting breakpoints 1
starting 1
viewing source code 1
watching variables and input 1

PUBLIC logical group 1

Q

quantified predicate 1
quantifiers 1

R

raw device 1

databank off 1
databank on 1
partition 1

RDBMS 1
READLOG 1

change program ID 1
functions 1
list definitions 1

log list file 1
log list width 1

listing operations 1

all 1
specified tables 1
tables in databank 1

listing restrictions 1

databank 1
ident 1
time interval 1

output format 1

read-only cursors 1, 2
read-only result sets 1
read-set 1
REFERENCES 1, 2, 3

privileges 1

REFERENCES privilege 1
referential integrity 1, 2, 3, 4
relational operators 1
RELEASE 1
relocating databanks

system 1
user 1

REMOTE section 1
REOPENABLE 1

cursors 1

REPEAT 1, 2
REPEAT statement 1
REPLACE 1
reserved words 1, 2, 3
reset log 1
RESIGNAL 1
RESIGNAL statement 1
resignaling exceptions in routines 1
restore 1
RESTRICT 1, 2, 3, 4, 5, 6
restriction views 1
Result 1
result set procedure CALL 1
result set procedures 1
result table 1
RETAIN 1
retrieving

multiple tables 1
single rows 1

retrieving data 1

from multiple tables 1
from single tables 1

retrieving single rows 1
RETURN 1
RETURN statement 1
RETURNED_LENGTH 1
RETURNED_OCTET _LENGTH 1
RETURNED_SQLSTATE 1
REVOKE

ACCESS PRIVILEGE 1
OBJECT PRIVILEGE 1
SYSTEM PRIVILEGE 1

revoking privileges 1

recursive effects 1, 2

RIGHT OUTER JOIN 1
rights. See privileges 1
ROLLBACK 1, 2
ROUND 1
ROUTINE_CATALOG 1
ROUTINE_NAME 1
ROUTINE_SCHEMA 1
routines 1, 2, 3

access clause 1
access rights 1
ATOMIC compound SQL Statement 1
comments in 1
compound SQL statement 1
declaring

exception handlers 1
variables 1

deterministic clause 1
IF statement 1
invoking 1
LEAVE statement 1
managing exception conditions 1
parameters 1
restrictions 1
scope in 1
SQL constructs

IF 1
SET 1

SQL constructs in 1
using drop and revoke 1
write operations 1

ROW 1
ROW_COUNT 1, 2
run-time errors 1

S

scalar functions 1, 2

using 1

scalar interval functions 1
scalar string functions 1
scale 1
SCHEMA 1

privilege 1, 2

schema 1, 2

creating 1

SCHEMA_NAME 1
schemas 1, 2

data dictionary 1
dropping 1, 2

SCROLL 1, 2
scrollable cursor 1, 2, 3
scrolling 1
SDBGEN 1

command-line arguments 1, 2
creating SYSADM 1
syntax 1

search conditions 1

precedence 1
truth tables 1

searched CASE 1
searching 1
searching for NULL 1
secondary index 1

creating 1
dropping 1
maintaining 1
use 1

secondary indexes 1

creating 1

SELECT 1, 2, 3

* 1
... AS column-label 1
ALL 1
COLLATE 1
computed values 1
correlation names 1
creating views 1
DISTINCT 1, 2
EXISTS 1
expression 1
FOR UPDATE OF 1
FROM 1
GROUP BY 1, 2
HAVING 1, 2
intermediate result sets 1
INTO 1
notes 1
NULL values 1
ORDER BY 1
ordering the result 1
privilege 1
privileges 1
quantified predicate 1
restrictions 1
SELECT clause 1
simple form 1
statement 1

in dynamic SQL 1

table.* 1
table-reference 1
UNION 1, 2
WHERE 1, 2

SELECT ... AS 1
SELECT clause 1
SELECT INTO 1
SELECT specification 1

standard compliance 1
syntax 1

SELECT statement 1
selecting groups 1
selection process 1
semantic errors 1
separator 1
sequence 1, 2

creating 1

sequences 1

data dictionary 1

SERVER_NAME 1
SESSION_USER 1
SET 1

CONNECTION 1, 2
DATABANK 1
DATABASE 1
DESCRIPTOR 1
SESSION 1
SHADOW 1
TRANSACTION 1

set conditions 1
set functions 1, 2

standard compliance 1

SET SESSION 1
SET statement 1
SET TRANSACTION 1, 2

access mode 1
CHANGES 1
ISOLATION LEVEL 1

options 1

READ ONLY 1
READ WRITE 1
START 1

SHADOW 1

privilege 1

Shadow

creating 1
dropping 1
not accessible 1

shadow 1
shadow databank

creating 1

shadow databank name 1
shadow databanks

dropping 1

shadow file extension 1
SHADOW privilege 1
Shadowing 1

databank 1
listing information 1
LOGDB shadow to a master 1
LOGDB Shadow to Master 1
logging 1
management 1
performance 1
privileges 1
shadow to master 1
SYSDB Shadow to Master 1
system databanks 1
testing 1
transaction control 1
TRANSDB shadow to master 1
troubleshooting 1
utilities 1

shadowing 1
shadowing in backup and restore 1
Shadows

backing-up from 1

shadows 1

data dictionary 1

SIGN 1
SIGNAL 1
SIGNAL statement 1
signaling exceptions in routines 1
simple CASE 1
simple joins 1
SINGLEDEFS file 1
single-row SELECT 1
singleton 1, 2
SINGLETON SELECT 1
single-user mode access to a database 1

file protection 1
MIMER_MODE variable 1
the SINGLEDEFS file 1

SOME 1, 2
sort order

character set 1
in SELECT 1
index 1

SOUNDEX 1
source table 1
specific exception handlers 1
SPECIFIC_NAME 1
specifying default values 1
SQL 1

access control statements 1
compiler 1
connection statements 1
constructs in routines 1
data definition statements 1
descriptor area 1
dynamic 1
dynamic statements 1
embedded control statements 1
standards 1

limits 1

statement identifier 1
statements 1

errors 1
using host variables 1

vendor-specific 1

SQL compiler 1
SQL descriptor area 1

allocate 1
COUNT field 1, 2, 3, 4
deallocate 1
get values 1
item descriptor area 1

CHARACTER_SET_ CATALOG 1
CHARACTER_SET_ NAME 1
CHARACTER_SET_ SCHEMA 1
COLLATION_CATALOG 1
COLLATION_NAME 1
COLLATION_SCHEMA 1
DATA 1
DATETIME data types 1
DATETIME_INTERVAL _CODE 1
DATETIME_INTERVAL _PRECISION 1
INDICATOR 1
INTERVAL data types 1
LENGTH 1
NAME 1
NULLABLE 1
OCTET_LENGTH 1
PARAMETER_MODE 1
PARAMETER_ORDINAL_POSITION 1
PARAMETER_SPECIFIC_CATALOG 1
PARAMETER_SPECIFIC_NAME 1
PARAMETER_SPECIFIC_SCHEMA 1
parameters 1
PRECISION 1
RETURNED_LENGTH 1
RETURNED_OCTET _LENGTH 1
SCALE 1
TYPE 1
TYPE field 1
UNNAMED 1

set values 1
setting the TYPE field 1
structure 1

SQL statement

about 1

SQL statements 1, 2

access control 1
ALTER DATABANK 1
ALTER DATABANK RESTORE 1
ALTER IDENT 1
ALTER SHADOW 1
connection 1
data definition 1
data manipulation 1
database administration 1
transaction control 1

SQL statements for managing databank backups 1
SQL/PSM 1
SQLDA 1, 2

in FETCH statements 1
in OPEN 1
in PREPARE 1

SQLDB 1

backups of 1
initial creation 1

SQLERROR 1
SQLHOSTS file 1
SQLPOOL 1
SQLSTATE 1, 2, 3, 4

class 1
fields 1, 2
list of values 1
return codes 1
subclass 1

SQLWARNING 1
stacking cursors 1
standard compliance

assigning values 1, 2
data types 1
expressions 1
fixed values 1
identifiers 1
JOIN 1
literals 1
operators 1, 2
predicates 1, 2
scalar functions 1
SELECT specification 1
set functions 1, 2
statements (also see individual statements) 1

START 1
statement

delimiters

in COBOL 1
in FORTRAN 1

margins

in FORTRAN 1

numbers

in FORTRAN 1

statement-information 1
statements

access control 1
connection 1
data definition 1
dynamic SQL 1
embedded SQL control 1
preparing 1

STATISTICS 1

privilege 1

statistics on data access 1

authorization 1

STATISTICS privilege 1
status 1
stored procedures 1

access rights and routines 1
CASE statement 1
comments 1
declaring condition names 1
functions 1
invoking procedures and functions 1
ITERATE 1
modules 1
ODBC 1
procedures 1
result set procedures 1
routines 1
using cursors 1

restrictions 1

string

character 1
comparisons 1
empty 1
expressions 1
hexadecimal 1
literals 1
operators 1

string concatenation 1
string pseudo literals 1
SUBCLASS_ORIGIN 1
subprogram names 1
subroutine names 1
subselect

in INSERT 1
in UNION queries 1
in view definition 1

subselects 1

in INSERT 1

SUBSTRING 1, 2
SUM 1, 2
synonym 1

creating 1

synonyms 1, 2

creating 1
data dictionary 1
dropping 1

syntax diagrams

explanation 1
keywords 1

syntax errors 1, 2
SYSADM 1, 2, 3, 4

administration 1
privileges and access 1

SYSADM privileges 1
SYSDB 1

initial creation 1

system

privileges 1

system databanks 1, 2, 3
system failure 1
system management 1
system objects 1
system privileges 1, 2, 3, 4

BACKUP 1
DATABANK 1
examples 1
granting 1
IDENT 1
revoking 1
SHADOW 1
STATISTICS 1

T

TABLE 1, 2

privileges 1

table 1, 2

adding columns 1
base 1
changing column defaults 1
changing definition 1
constraints

dropping 1

creating 1
deleting rows 1
inserting rows 1
reference 1
updating contents 1

table access errors 1
table integrity 1
TABLE_NAME 1
tables 1

altering 1
base and views 1
check conditions 1
column definitions 1
creating 1
data dictionary 1
dropping 1
entering data 1
joined 1

TAIL 1
target_variables 1
threads 1

request 1

TRANS databank option 1, 2
TRANS option 1
transaction

consistency 1
control options 1
control statements 1
diagnostics size 1
logging 1

options 1

optimization 1
phases 1

transaction control 1
transaction control statements 1

COMMIT 1
ROLLBACK 1
SET SESSION 1
SET TRANSACTION 1
START 1

TRANSACTION_ACTIVE 1
TRANSACTIONS 1
transactions 1, 2

aborting 1
build-up 1
CHANGES setting 1
COMMIT 1
committing 1
conflict 1
consistency 1
control options 1, 2
control statements 1
cursors 1
default settings 1
designing 1

loops 1

diagnostics size 1
disk crash 1
ending 1
error handling 1
interrupted 1
ISOLATION LEVEL 1
isolation levels 1
locking 1
logging 1

LOG 1
NULL 1
TRANS 1

ODBC 1
optimistic concurrency control 1
optimizing 1
READ ONLY 1
read only 1
READ WRITE 1
read write 1
read-set 1
ROLLBACK 1
rollback 1
START setting 1
starting 1, 2

explicit 1
implicit 1

write-set 1

TRANSDB 1

backups of 1
initial creation 1

treads

background 1

tree structure

traversing 1

trigger 1

creating 1, 2

TRIGGER_CATALOG 1
TRIGGER_NAME 1
TRIGGER_SCHEMA 1
triggers 1, 2

action 1
comments 1
creating 1
data dictionary 1
dropping 1
event 1
recursion 1
REFERENCING clause 1
revoking 1
table aliases 1
time 1

AFTER 1

altered rows 1

BEFORE 1
INSTEAD OF 1

TRIM 1, 2
TRUNCATE 1
truncating decimal values 1
truncating string values 1
truth tables 1, 2
TYPE 1
TYPE fields 1
types 1

U

unary operators 1
undefined values 1
UNION 1, 2
unique constraints 1
UNIQUE index 1
UNIX 1

environment variables 1
raw device 1

UNLOAD 1, 2

AS 1
examples 1
FROM 1
LOG 1
syntax 1
USING 1

UNNAMED 1
updatable result sets 1
updatable views 1, 2
UPDATE 1, 2, 3, 4, 5

privileges 1

UPDATE CURRENT 1, 2
UPDATE privilege 1
UPDATE STATISTICS 1
upgrading

databanks 1

UPPER 1, 2
USAGE 1, 2

privileges 1

usage modes 1

embedded 1
interactive 1
JDBC 1
ODBC 1
procedural 1

user databanks 1, 2, 3

specifying location 1

USER ident 1, 2
user ident 1
USER idents 1
user idents 1
UTIL 1

V

value specification 1
value specifications

standard compliance 1

variables 1

declaring 1, 2
host 1
value assignment 1

Vendor-specific SQL 1
view integrity 1
Views

restriction 1

views 1, 2, 3

CHECK OPTION 1
check options 1, 2
column names 1
creating 1, 2
creating on 1
data dictionary 1
dropping 1
inserting rows 1
join 1
restriction 1
updatable 1

views - use in database security 1

W

warnings 1
WEEK 1
WHENEVER 1, 2

in transactions 1

WHERE 1
WHERE condition 1
WHILE 1
WHILE statement 1
white-space 1, 2, 3
wildcard characters 1
wildcards 1
write-set 1

X

X/Open SQL 1995 1
X/Open-95 1

Y

YEAR 1
YEAR-MONTH 1

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