Mimer SQL Documentation TOC PREV NEXT INDEX

Mimer SQL Developer Site


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 STATEMENT 1
ALTER TABLE 1, 2
Alternate Weighting 1
ANSI/ISO 1
ANY 1, 2
APIs
embedded SQL 1
JDBC 1
Application Server 1
arccosine 1
arcsine 1
arctangent 1, 2
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
Audit trail 1
audit trail 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 Accent Ordering 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
Block Fetching 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
GET DIAGNOSTICS 1
LIST 1
LOG 1
READ INPUT 1
SET ECHO 1
SET EXECUTE 1
SET EXPLAIN 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, 2
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, 3
rules 1, 2
CASE expression 1
COALESCE 1
is NULLIF 1
NULLIF 1
rules 1, 2
short forms 1
CAST 1, 2
CAST specification 1
example 1
rules 1
CATALOG_NAME 1
CEILING 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 VARYING(n) 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 1
maximum length 1, 2
CLOSE 1
closing a cursor 1
COALESCE 1
COBOL 1, 2
comments 1
data types 1
host variables 1
line continuation 1
preprocessor output 1
statement delimiters 1
COLLATE 1
collation 1, 2, 3
creating 1
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
COM+ 1
COMMAND_FUNCTION 1, 2
command-line arguments
MIMCONTROL 1
MIMINFO 1
SDBGEN 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
constants 1
CONSTRAINT_CATALOG 1
CONSTRAINT_SCHEMA 1
constraints
referential 1
unique 1
CONTINUE 1
contractions 1
correlation names 1, 2
cosine 1
cotangent 1
COUNT 1, 2
CREATE
BACKUP 1
COLLATION 1
DATABANK 1
DOMAIN 1
FUNCTION 1
IDENT 1
INDEX 1
MODULE 1
PROCEDURE 1
SCHEMA 1
SEQUENCE 1
SHADOW 1
STATEMENT 1
SYNONYM 1
TABLE 1
TRIGGER 1
VIEW 1
creating
collations 1
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
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
resource allocation 1
retrieving data 1
SCROLL 1, 2
stacking 1
transactions 1
updatable 1
updating and deleting with 1
updating data 1

D

DACOS 1
DASIN 1
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
tables 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 DBC1
DATABANK privilege 1
databank shadows 1
databanks 1, 2
allocating disk space 1
altering 1
backup 1
changing location 1
creating 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
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
objects 1
offline 1
online 1
optimizing performance 1
private objects 1
privileges 1
remote 1
security 1
selecting 1
single-user mode 1
statistics 1
SYSADM 1
system objects 1
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
DATAN 1
DATAN2 1
DATE 1
datetime
arithmetic 1
functions 1
datetime and interval comparisons 1
datetime assignments 1
DATETIME data types 1
Datetime 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
DCOS 1
DCOT 1
DDEGREES 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 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
COLLATION 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
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
DEXP 1
diagnostics area 1, 2
DISCONNECT 1, 2
disconnecting 1
DISTINCT 1, 2
in set functions 1
DLOG 1
DLOG10 1
domain 1
creating 1
data integrity 1
dropping 1
domains 1, 2
check clause 1
creating 1
default value 1
default values 1
dropping 1
dormant cursors 1
DPOWER 1
DRADIAN 1
DROP 1, 2
drop
collation 1
drop behavior 1
drop log 1
dropping objects 1
DSIN 1
DSQRT 1
DTAN 1
DTC 1, 2
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

EJB 1
Embedded SQL
ESQL 1, 2
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
EOR 1
error
codes 1, 2
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
example database 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
EXLOAD 1, 2
exp 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
EXPTOLOAD 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
FLOOR 1
FOR UPDATE OF 1
FORALL 1
foreign keys 1, 2
data integrity 1
FORTRAN 1, 2
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
datetime pseudo literals
CURRENT_DATE 1
LOCALTIME 1
LOCALTIMESTAMP 1
invoking 1
scalar functions 1
standard compliance 1
scalar interval functions
ABS 1
scalar numeric functions 1
ASCII_CODE 1, 2
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
ASCII_CHAR 1, 2
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
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
user-defined 1

G

general exception handlers 1
GET DESCRIPTOR 1
GET DIAGNOSTICS 1, 2
COMMAND_FUNCTION 1
DYNAMIC_FUNCTION 1
exception-info 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
PARAMETER_NAME 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
holdable 1
holdable cursor 1, 2, 3, 4
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
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
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

J2ME Wireless Toolkit 1
JDBC 1, 2, 3
driver 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
foreign 1
primary 1
keywords
in syntax diagrams 1

L

labels in SELECT clause 1
languages 1
LEAVE 1, 2, 3
(program ident) 1
LEAVE RETAIN 1
LENGTH 1
level-1 1
level-2 1
level-3 1
level-4 1
license key 1
LIKE 1, 2
escape characters 1
meta-characters 1
wildcards 1
limits 1
line continuation
in COBOL 1
in FORTRAN 1
Linguistic Sorting 1, 2
LIST
COLLATIONS 1
DATABANK 1
DATABANKS 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
LOCALTIME 1
LOCALTIMESTAMP 1
locating databank files 1
log 1, 2
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
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, 2
syntax 1
MIMSERV 1
mimtcp 1
MIN 1, 2
minus sign
in COBOL variable names 1
MOD 1
modules 1, 2, 3, 4
creating 1, 2
MORE 1
MSDTC 1
MTS 1
Multilevel Comparisons 1
multiple connections 1

N

NAME 1
national character
data 1
NCHAR 1
strings 1
NATIONAL CHARACTER LARGE OBJECT 1
NATIONAL CHARACTER VARYING(n) 1
NATIONAL CHARACTER(n) 1
national-character-string-literal 1
NATIVE_ERROR 1
NATURAL JOIN 1
natural joins 1
NCHAR 1
NCHAR VARYING(n) 1
NCHAR(n) 1
NCLOB 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
NVARCHAR 1

O

object
privileges 1
EXECUTE 1
MEMBER 1
TABLE 1
USAGE 1
object privileges 1, 2, 3, 4, 5, 6
examples 1
EXECUTE 1
granting 1
MEMBER 1
revoking 1
TABLE 1
USAGE 1
OCC 1
OCTET_LENGTH 1, 2
ODBC 1
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
standard compliance 1, 2
optimistic concurrency control 1, 2
optimizing transactions
READ ONLY and READ WRITE 1
ORDER BY 1, 2
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
OVERLAPS 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_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
pdacopy 1
performance
database server 1
persistent stored modules - See stored procedures1
Personal Java 1
platforms 1
POSITION 1, 2
power 1
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
Primary Keys 1
primary keys 1
indexes 1
Primary level 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
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
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 procedures1
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
Quaternary level 1

R

radian 1
random 1
RDBMS 1
READLOG
functions 1
list definitions 1
list properties 1
log file 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
readlog 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
REOPENABLE 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 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 privileges1
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 subquery 1
scale 1
SCHEMA 1
privilege 1, 2
schema 1, 2
creating 1
SCHEMA_NAME 1
schemas 1, 2
dropping 1
SCROLL 1, 2
scrollable cursor 1, 2, 3
SDBGEN 1
command-line arguments 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
creating 1
Secondary level 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
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
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
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
shadowing 1
shadowing in backup and restore 1
Shadows
backing-up from 1
shadows 1
SIGN 1
SIGNAL 1
SIGNAL statement 1
signaling exceptions in routines 1
simple CASE 1
simple joins 1
sin 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
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
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
SQLPOOL 1
SQLSTATE 1, 2, 3, 4
class 1
fields 1, 2
list of values 1
return codes 1
subclass 1
SQLWARNING 1
square root 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, 2
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
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
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, 2
initial creation 1
system
privileges 1
system databanks 1, 2, 3
system failure 1
system management 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
dropping 1
entering data 1
joined 1
TAIL 1
Tailorings 1
tan 1
target_variables 1
Tertiary level 1
threads 1
request 1
TRANS databank option 1, 2
TRANS option 1
transaction
consistency 1
control options 1
control statements 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, 2
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
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
UNICODE_CHAR 1
UNICODE_CODE 1
unicode-character-string-literal 1
UNION 1, 2
Unique Constraints 1
unique constraints 1
UNIQUE index 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
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
specifying location 1
USER ident 1, 2
user ident 1
USER idents 1
user idents 1

V

value specification 1
value specifications
standard compliance 1
VARCHAR(n) 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
dropping 1, 2
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
WITH HOLD 1, 2
write-set 1

X

X/Open SQL 1995 1
X/Open-95 1
XA 1, 2

Y

YEAR 1
YEAR-MONTH 1

Mimer
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
info@mimer.se
Mimer SQL Documentation TOC PREV NEXT INDEX