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

Master Index

Symbols

@ 1, 2

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
ADO.NET 1
AFTER 1
ALL 1, 2, 3
in SELECT clause 1
predicate 1
ALLOCATE CURSOR 1
ALLOCATE DESCRIPTOR 1
ALTER DATABANK 1, 2
INTO 1
SET FILESIZE 1
TO
LOG 1
TRANSACTION 1
WORK 1
ALTER DATABANK RESTORE 1
filename-string 1
LOG 1
ALTER DATABASE 1
ALTER IDENT 1, 2
ALTER SEQUENCE 1
ALTER SHADOW 1
ALTER STATEMENT 1
ALTER SUBSCRIPTION 1
ALTER TABLE 1, 2
Alternate Weighting 1
ANSI/ISO 1
ANY 1, 2
APIs
embedded SQL 1, 2, 3
Application Server 1
arccosine 1
arcsine 1
arctangent 1
arithmetic operations 1
arithmetical operators 1
arrays 1
AS
for column labels 1
AS_DECIMAL 1, 2
AS_TEXT 1, 2, 3
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
automatic upgrade 1
AUTOUPGRADE 1, 2, 3, 4
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
Batch SQL 1
BEFORE 1
BEGIN DECLARE SECTION 1, 2
BEGINS 1
BETWEEN 1
BETWEEN operator 1
BIGINT 1
BINARY 1
BINARY LARGE OBJECT 1
binary operators 1
BINARY VARYING 1
BIT_LENGTH 1
BLOB 1
Block Fetching 1
Boolean 1
BSQL 1
batch jobs 1
command-line arguments 1
commands 1
errors in 1
host variables 1
logging in 1
running 1
script jobs 1
syntax descriptions 1
Unix command line 1
variables 1
bsql 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
builtin.gis_coordinate 1
builtin.gis_latitude 1
builtin.gis_location 1
builtin.gis_longitude 1
BUILTIN.UTC_TIMESTAMP 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, 7
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
case folding 1
CAST 1, 2
CAST specification 1
example 1
rules 1
CEILING 1
changing connections 1
changing databank file location 1
changing passwords 1
changing shadow to master databank 1
CHAR(n) 1
CHAR_LENGTH 1, 2
CHARACTER 1
CHARACTER LARGE OBJECT 1
character set 1, 2
character string 1
character string comparison 1
CHARACTER VARYING 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
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
dropping 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 TYPE 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
COM+ 1
COMMAND_FUNCTION 1
command-line arguments
MIMCONTROL 1
MIMINFO 1
SDBGEN 1, 2
COMMENT 1
comment
dropping 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
compress 1
computed values 1
concatenation 1
concurrency control 1, 2
condition names
declaring 1
conditional execution
CASE 1
IF 1
CONNECT 1
backward compatibility syntax 1
CONNECT SOURCE USER 1
CONNECT TARGET USER 1
connecting 1
connection name 1, 2
connection statements 1, 2
CONNECT 1
DISCONNECT 1
ENTER 1
LEAVE 1
SET CONNECTION 1
connections
cursors 1
constants 1
CONSTRAINT_CATALOG 1
constraints
referential 1
unique 1
constructor method 1
constructor-method-invocation 1
CONTINUE 1
contractions 1
coordinate 1
coordinate system 1
Coordinated Universal Time 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
CREATE SUBSCRIPTION 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 JOIN 1
cross product 1
current locale 1
current row 1
CURRENT VALUE 1
CURRENT_DATE 1
CURRENT_PROGRAM 1
CURRENT_USER 1
cursor
closing 1
cursor stack 1, 2
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
CYCLE 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, 3
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
C/C++ 1
CHAR(n) 1
CHARACTER(n) 1
compatibility 1
compatibility in FETCH statements 1
conversion 1, 2, 3, 4
DATE TIME TIMESTAMP 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
DAY 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
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
dbc 1
dbfiles 1
dbinstall 1
DBOPEN 1
authorization 1
background threads 1
command-line arguments 1
functions 1
multi-user mode 1
output example 1
dbopen 1
dbuninstall 1
DCOS 1
DCOT 1
DDEGREES 1
DDL 1
deadlock 1
DEALLOCATE
DESCRIPTOR 1
PREPARE 1
deallocating cursor resources 1
debugging 1
DECIMAL 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
DELETE STATISTICS 1
delimited identifier 1
delimiting complex statements with @ 1
deprecated features 1, 2
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
METHOD 1
MODULE 1
PROCEDURE 1
SCHEMA 1
SEQUENCE 1
SHADOW 1
SPECIFIC 1
SPECIFICATION 1
SYNONYM 1
TABLE 1
TRIGGER 1
TYPE 1
VIEW 1
DESCRIBE INPUT 1
DESCRIBE SELECT LIST 1
DESCRIBE SUBSCRIPTION 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
DISCONNECT SOURCE 1
DISCONNECT TARGET 1
disconnecting 1
disk representation 1
DISTINCT 1, 2
in set functions 1
distinct type 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
DOUBLE PRECISION 1
DPOWER 1
DRADIANS 1
DROP 1, 2
drop behavior 1, 2
drop log 1
DROP SUBSCRIPTION 1
dropping objects 1
DSIN 1
DSQRT 1
DTAN 1
DTC 1, 2
duplicate values 1
dynamic SQL 1
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
executing 1, 2
opening cursors 1
preparing 1
source form 1
DYNAMIC_FUNCTION 1

E

ELSE 1, 2
ELSEIF 1
Embedded SQL
ESQL 1
host languages 1
program structure 1
scope 1
statements 1
embedded SQL control statements 1
END DECLARE SECTION 1, 2
Engine server 1
ENTER 1
ENTER SOURCE 1
ENTER TARGET 1
entity integrity 1
environment variables 1
EOR 1
error
codes 1, 2
handling 1
error codes 1, 2
Error 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
ESCAPE in LIKE conditions 1
ESQL 1, 2, 3
esql 1
evaluating cursor declaration 1
EXCEPT 1, 2
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
EXISTS 1
condition 1
NULL values 1
EXIT 1
EXLOAD 1
exload 1
exp 1
Experience server 1
expression 1
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
exptoload 1
extended cursor
allocate 1
DELETE CURRENT 1
UPDATE CURRENT 1
EXTRACT 1, 2

F

FETCH 1, 2, 3
scrollable cursor 1
FETCH FIRST 1
file extension
shadow databank 1
file location
databank 1, 2
FILESIZE 1, 2
FIPS_DOCUMENTATION 1
FLOAT 1
floating point literals 1
FLOOR 1
FOR loop 1
FOR UPDATE OF 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
function
dropping 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
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
condition-info 1
DYNAMIC_FUNCTION 1
exception-info
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
ERROR_LENGTH 1
ERROR_POSITION 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
GIS 1
GOALSIZE 1, 2
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, 2
C/C++ 1, 2
COBOL 1, 2
FORTRAN 1, 2
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
HOUR 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
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
PROGRAM 1
program 1
structure 1
USER 1
user 1
IF 1
Immediate restart 1
implicit connection 1
IN condition 1
IN predicate 1
INCLUDE SQLCA 1
included code
host language 1
increment 1
index 1
INDEX_CHAR 1
indexes 1, 2
indexing
automatic 1, 2
Indic 1
indicator variable 1
indicator variables 1, 2
including 1
INFO_SCHEM 1
INFORMATION_SCHEMA 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
INSIDE_RECTANGLE 1, 2
install 1
instance method 1
instance-method-invocation 1
INSTEAD OF 1
INTEGER 1
integer literals 1
integrity
domains 1
foreign key 1
in view definitions 1
primary key 1
within tables 1
INTERFACE 1
intermediate result sets 1
INTERSECT 1, 2
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 LEVEL 1
isolation levels 1
isolation levels in transactions 1
item descriptor area 1
ITERATE 1, 2, 3
iteration 1
LOOP statement 1
REPEAT statement 1
skip 1
WHILE statement 1
iterative execution
LOOP 1
REPEAT 1
WHILE 1

J

Japanese 1
JDBC 1
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
outer 1
simple 1

K

Kanji 1, 2
keys
foreign 1
primary 1
keywords
in syntax diagrams 1
Korean 1

L

labels in SELECT clause 1
languages 1
LARGE OBJECT 1, 2
latitude 1, 2
LEAVE 1, 2
(program ident) 1
LEAVE RETAIN 1
LEAVE SOURCE 1
LEAVE TARGET 1
LENGTH 1
LEVEL 1
level-1 1
level-2 1
level-3 1
level-4 1
license key 1, 2
LIKE 1, 2
escape characters 1
meta-characters 1
wildcards 1
limits 1
line continuation
in COBOL 1
in FORTRAN 1
Linguistic Sorting 1
LIST
COLLATIONS 1
DATABANK 1
DATABANKS 1
DOMAINS 1
FUNCTIONS 1
IDENTS 1
INDEXES 1
METHODS 1
MODULES 1
OBJECTS 1
PROCEDURES 1
SCHEMATA 1
SEQUENCES 1
SHADOWS 1
SPECIFICATIONS 1
STATEMENTS 1
SYNONYMS 1
TABLES 1
TRIGGERS 1
TYPES 1
VIEWS 1
LIST SUBSCRIPTIONS 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
locale 1, 2
LOCALTIME 1
LOCALTIMESTAMP 1
locating databank files 1
location 1
LOG 1
log 1
LOG databank option 1, 2
log file 1
LOG option 1, 2
log tables 1
LOGDB 1, 2
information contained in 1
initial creation 1
logging 1
options 1
logical operators 1
longitude 1, 2
LOOP 1, 2
LOOP statement 1
LOWER 1, 2

M

MASTER 1
MAX 1, 2
MAXSIZE 1, 2
MAXVALUE 1
MEMBER 1, 2
privileges 1
MEMBER privilege 1
messages 1
meta-characters 1
method 1
dropping 1
method-invocation 1
mimaddpath 1
mimadmin 1
mimautoset 1
MIMCONTROL 1
command-line arguments 1
syntax 1
mimcontrol 1
mimdbfiles 1
mimdbserver 1
mimdbvis 1
mimdesktop 1
mimdevenv 1
MIMDUMP 1
mimdumper 1
mimengine 1
Mimer SQL 1
basic concepts 1, 2
database objects 1
publications 1
Mimer SQL license key 1
Mimer SQL system databanks 1
generating 1
MIMER_LOCALE 1, 2
MIMER_MODE variable 1
mimexampledb 1
mimexec 1
mimexper 1
mimhome 1
mimhosts 1
miminetd 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
Real-time report 1
real-time report 1
SQLPOOL report 1, 2
syntax 1
users list 1, 2
using 1
Version report 1
version report 1
miminfo 1
miminstall 1
mimjdbcver 1
MIMLICENSE
syntax 1
mimlicense 1
mimlink 1
mimlistdb 1
MIMLOAD 1, 2
command-line arguments 1
examples 1
exit codes 1, 2
syntax 1
mimload 1
mimlocation 1
mimmem 1
mimodbc 1
mimodbcadmin 1
mimodbcdm 1
mimowner 1
mimpath 1
mimperf 1
mimproc 1
MIMREPADM 1
options 1
mimrepadm 1
MIMSERV 1
mimservers 1
mimsqlhosts 1
mimstatln 1
MIMSYNC 1
mimsync 1
mimsysconf 1
mimtcp 1, 2, 3, 4
mimuninstall 1
mimunlink 1
mimversion 1
MIN 1, 2
MINSIZE 1, 2
minus sign
in COBOL variable names 1
MINUTE 1
MINVALUE 1
MOD 1
module
dropping 1
modules 1, 2, 3, 4
creating 1, 2
MONTH 1
MSDTC 1
MTS 1
MULTIDEFS
mimtcp 1
MULTIDEFS file 1
Multilevel Comparisons 1
multiple connections 1
mutator method 1

N

NAME 1
NATIONAL CHARACTER 1
national character
data 1
NCHAR 1
strings 1
NATIONAL CHARACTER LARGE OBJECT 1, 2
NATIONAL CHARACTER VARYING 1
NATIONAL CHARACTER VARYING(n) 1
NATIONAL CHARACTER(n) 1
national-character-string-literal 1
NATURAL JOIN 1
NCHAR 1, 2
NCHAR LARGE OBJECT 1
NCHAR VARYING 1
NCHAR VARYING(n) 1
NCHAR(n) 1
NCLOB 1, 2
nested selects 1
nesting 1
NEW 1
NEXT VALUE 1
NO CYCLE 1
NODE 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
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
NULLABLE 1
NULLIF 1
NUMERIC 1
numerical
assignments 1
comparisons 1
data
precision and scale 1
literals 1
strings 1
NVARCHAR 1, 2

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
observer method 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
standard compliance 1, 2
optimistic concurrency control 1, 2
optimizing transactions
READ ONLY and READ WRITE 1
ORDER BY 1, 2
order-by-clause 1
orientation specification 1
OS_USER 1, 2
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 overloading 1, 2, 3, 4, 5
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
passwords 1
PASTE 1
pattern conditions 1
performance
database server 1
persistent stored modules - See stored procedures1
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
procedure
dropping 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
program construction errors 1
PROGRAM ident 1
program ident 1, 2
PROGRAM idents 1, 2
program idents 1
EXECUTE privilege 1
leaving 1
retaining resources 1
program structure 1
PROTOCOL 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
raw device 1
databank off 1
databank on 1
partition 1
RDBMS 1
READ ONLY 1
READ ONLY databank option 1
READ ONLY option 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
REAL 1
Real-Time 1
REFERENCES 1, 2, 3
privileges 1
REFERENCES privilege 1
referential integrity 1, 2, 3, 4
REGEXP_MATCH 1
regular expression 1
relational operators 1
RELEASE 1
relocating databanks
system 1
user 1
REMOTE section 1
REMOVABLE 1
REOPENABLE 1
REPEAT 1, 2, 3
REPEAT statement 1
REPLACE 1
replication 1
REPSERVER 1
repserver 1
requirements 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, 7
restriction views 1
RESULT OFFSET 1
result set procedure CALL 1
result set procedures 1
result table 1
result-offset-clause 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
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
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 trigger 1
ROW_COUNT 1
row-expression 1
RTAPI 1
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
dropping 1
schemas 1, 2
script jobs
security 1
SCROLL 1, 2
scrollable cursor 1, 2, 3
SDBGEN 1
command-line arguments 1
syntax 1
sdbgen 1
search conditions 1
precedence 1
truth tables 1
searched CASE 1
searching 1
searching for NULL 1
SECOND 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
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
WHERE 1, 2
SELECT ... AS 1
SELECT clause 1
SELECT INTO 1
SELECT specification 1
standard compliance 1
SELECT statement 1
select-expression 1
select-expression-body 1
selecting groups 1
selection process 1
select-specification 1
semantic errors 1
separator 1
SEQUENCE 1
sequence 1, 2, 3
creating 1
dropping 1
sequences 1
server name 1
SERVICE 1
SESSION_USER 1
SET 1
CONNECTION 1, 2
DATABANK 1
DATABASE 1
DESCRIPTOR 1
SESSION 1
SHADOW 1
TRANSACTION 1
SET COMPRESS 1
set conditions 1
set functions 1, 2
SET PAGESIZE 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
dropping 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
SHOW SETTINGS 1
SIGN 1
SIGNAL 1
SIGNAL statement 1
signaling exceptions in routines 1
simple CASE 1
simple joins 1
sin 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
SMALLINT 1
SOME 1, 2
sort order
character set 1
index 1
SOUNDEX 1
source database 1
source table 1
spatial data 1
specific exception handlers 1
specific name 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
embedded control statements 1
standards 1
statement identifier 1
statements 1
errors 1
using host variables 1
SQL compiler 1
SQL descriptor area 1
allocate 1
COUNT field 1, 2, 3, 4
deallocate 1
get values 1
in FETCH statements 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, 2
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
SQL_DESC_DISPLAY_SIZE_64 1
SQL_DESC_LENGTH_64 1
SQL_DESC_OCTET_LENGTH_64 1
SQL_DESC_OCTET_LENGTH_PTR_64 1
sqlcode 1
SQLDA 1, 2
in OPEN 1
in PREPARE 1
SQLDB 1
backups of 1
initial creation 1
SQLDriverConnect 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
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
statements (also see individual statements) 1
START 1
start value 1
statement
delimiters
in COBOL 1
in FORTRAN 1
dropping 1
margins
in FORTRAN 1
numbers
in FORTRAN 1
statement trigger 1
statement-information 1
statements
access control 1
connection 1
data definition 1
embedded SQL control 1
preparing 1
static method 1
static-method-invocation 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
structured type 1
subprogram names 1
subroutine names 1
subscription 1
subselect
in INSERT 1
in UNION queries 1, 2
in view definition 1
subselects 1
in INSERT 1
SUBSTRING 1, 2
SUM 1, 2
synchronization 1
synonym 1
creating 1
dropping 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
dropping 1
inserting rows 1
reference 1
updating contents 1
table access errors 1
table integrity 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 database 1
target_variables 1
TEMPORARY databank option 1
Tertiary level 1
threads 1
request 1
TIME 1
TIMESTAMP 1
TOP_LEVEL_COUNT 1
TRANSACTION 1
transaction
consistency 1
control options 1
control statements 1
logging 1
options 1
optimization 1
phases 1
transaction conflict 1
transaction control 1
transaction control statements 1
COMMIT 1
ROLLBACK 1
SET SESSION 1
SET TRANSACTION 1
START 1
TRANSACTION databank option 1, 2
TRANSACTION option 1, 2
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
dropping 1
triggers 1, 2, 3, 4
action 1
comments 1
creating 1
dropping 1
event 1
recursion 1
revoking 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
dropping 1
TYPE fields 1
type precedence 1, 2
types 1

U

unary operators 1
undefined values 1
Unicode delimited identifier 1
UNICODE_CHAR 1
UNICODE_CODE 1
unicode-character-string-literal 1
uninstall 1, 2
UNION 1, 2
Unique Constraints 1
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
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
USER_DEFINED_TYPE_CATALOG 1
USER_DEFINED_TYPE_CODE 1
USER_DEFINED_TYPE_NAME 1
USER_DEFINED_TYPE_SCHEMA 1
user-defined type 1
UTC_TIMESTAMP 1

V

value specification 1
value specifications
standard compliance 1
value-expression 1
VARBINARY 1
variables 1
declaring 1, 2
host 1
value assignment 1
version, server 1
Vietnamese 1
view
dropping 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
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, 2
WHILE statement 1
white-space 1, 2, 3
wildcard characters 1
wildcards 1
WITH HOLD 1, 2
WITHOUT CHECK 1, 2, 3, 4
WORK 1
WORK databank option 1
WORK option 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