Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


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

Index


A

aborting transactions 1
ABS 1
access control statements 1
access privileges 1, 2
DELETE 1
granting 1
INSERT 1
REFERENCES 1
revoking 1
SELECT 1
UPDATE 1
access rights 1
access-clause for procedures 1
ALL 1
in SELECT clause 1
in set functions 1
ALL predicate 1
ALLOCATE CURSOR 1
ALLOCATE DESCRIPTOR 1
ALTER DATABANK 1
ALTER DATABANK RESTORE 1
ALTER IDENT 1
ALTER SHADOW 1
ALTER TABLE 1
ANSI/ISO 1
ANY 1
ANY or SOME predicate 1
arithmetical operators 1
arithmetical precedence 1
ASCII_CHAR 1
ASCII_CODE 1
assigning values 1
standard compliance 1, 2
assignment
SET 1
averaging integers with decimal result 1
AVG 1

B

backup
databank 1
BACKUP privilege 1
backward compatibility 1
basic predicate 1
subselect 1
BEGIN DECLARE SECTION 1
BETWEEN 1
BIGINT data type 1
BINARY data type 1
binary operators 1
BINARY VARYING data type 1
BIT_LENGTH 1

C

CALL 1
calling procedures 1
CASCADE 1, 2, 3, 4
CASE 1
CASE expression 1
standard compliance 1
CAST specification 1
standard compliance 1
changing databank file location 1, 2
changing databank specification 1
changing password 1
changing shadow to master databank 1
CHAR_LENGTH 1
CHARACTER data type 1
character set 1
character string 1
CHARACTER VARYING data type 1
CHECK
in domain 1
check conditions 1
CHECK OPTION
in view definition 1
check options 1
CLOSE 1
closing a cursor 1
COALESCE 1
collating sequence 1
column definition 1
column names
in UNION queries 1
in views 1
COMMENT 1
comments 1
changing 1
dropping 1
COMMIT 1
comparison operators 1
comparisons 1
truth tables 1
concatenation 1
condition names
declaring 1
conditional execution
CASE 1
IF 1
CONFORMANCE 1
CONNECT 1
backward compatibility syntax 1
connection statements 1
CONTINUE 1
correlation names 1
COUNT 1
CREATE BACKUP 1
CREATE DATABANK 1
CREATE DOMAIN 1
CREATE FUNCTION 1
CREATE IDENT 1
CREATE INDEX 1
CREATE MODULE 1
CREATE PROCEDURE 1
CREATE SCHEMA 1
CREATE SEQUENCE 1
CREATE SHADOW 1
CREATE SYNONYM 1
CREATE TABLE 1
CREATE TRIGGER 1
CREATE VIEW 1
creating
comments 1
databanks 1
domain 1
function 1
ident 1
module 1
procedure 1
schema 1
secondary index 1
sequence 1
shadow databank 1
synonym 1
table 1
trigger 1
view 1
CURRENT_DATE 1
CURRENT_PROGRAM 1
CURRENT_USER 1
CURRENT_VALUE 1
cursor
closing 1
cursor stack 1, 2, 3, 4
cursors
access rights 1
declaring 1
deleting current row 1
evaluating declaration 1
opening 1
position after delete 1
positioning in result set 1
REOPENABLE 1, 2, 3
retrieving data 1
SCROLL 1, 2
updating data 1

D

data
binary 1
numerical 1
data definition statements 1
data dictionary 1
data integrity 1
check conditions 1
check options 1
domains 1
foreign keys 1
data manipulation statements 1
data type
BIGINT 1
BINARY VARYING(n) or VARBINARY(n) 1
BINARY(n) 1
CHARACTER VARYING(n) or VARCHAR(n) 1
CHARACTER(n) 1
DATE TIME TIMESTAMP 1
DECIMAL(p, s) 1
DOUBLE PRECISION 1
FLOAT 1
FLOAT(p) 1
INTEGER 1
INTEGER(p) 1
INTERVAL 1
NUMERIC(p, s) 1
pseudo 1
REAL 1
SMALLINT 1
data type conversion 1, 2
between different numerical types 1
data types
abbreviations 1
compatibility 1
compatibility in FETCH statements 1
conversion 1
parameter markers 1
standard compliance 1
databank 1
backup 1
changing specification 1
creating 1
dropping 1
recovery 1
restoring 1
shadow 1
shadows offline 1
shadows online 1
databank file extension 1
databank file location 1, 2, 3
databank name 1, 2
DATABANK privilege 1
databanks 1
offline 1
online 1
system 1
user 1
database
connecting to 1
objects 1
offline 1
online 1
optimizing performance 1
private objects 1
system objects 1
DATE 1
datetime and interval comparisons 1
datetime assignments 1
DATETIME data types 1
Datetime literals 1
DAYOFWEEK 1
DAYOFYEAR 1
DAY-TIME 1
DEALLOCATE DESCRIPTOR 1
DEALLOCATE PREPARE 1
deallocating cursor resources 1
DECIMAL data type 1
decimal literals 1
declarative statements 1
DECLARE CONDITION 1
DECLARE CURSOR 1
DECLARE HANDLER 1
DECLARE SECTION 1
DECLARE VARIABLE 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
DELETE 1
DELETE CURRENT 1
DELETE privilege 1
deprecated features 1
SQLCODE 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
diagnostics statements 1
DISCONNECT 1
DISTINCT
in SELECT clause 1
in set functions 1
domain 1
creating 1
dropping 1
domains
data integrity 1
DOUBLE PRECISION data type 1
DROP 1, 2
drop behavior 1
dynamic SQL statements 1
executing 1, 2
opening cursors 1
preparing 1
source form 1

E

eliminating duplicate values 1
embedded SQL control statements 1
END DECLARE SECTION 1
ENTER 1
error
codes 1
handling 1
ESCAPE
in LIKE predicates 1
escape clause 1
evaluating cursor declaration 1
exception conditions 1
exception handlers
declaring 1
EXECUTE 1
EXECUTE IMMEDIATE 1
EXECUTE privilege
on procedure 1
on program ident 1
EXISTS 1
expressions
in SELECT 1
precision and scale 1
standard compliance 1
syntax 1
extended cursor
allocate 1
DELETE CURRENT 1
UPDATE CURRENT 1
extended statement 1
EXTRACT 1

F

FETCH 1
scrollable cursor 1
file extension
databank 1
shadow databank 1
file location
databank 1, 2, 3
fixed values
standard compliance 1
FLOAT data type 1
floating point literals 1
FOR UPDATE OF 1
foreign keys
data integrity 1
functions 1, 2
creating 1
user-defined 1

G

GET DESCRIPTOR 1
GET DIAGNOSTICS 1
GOTO 1
GRANT ACCESS PRIVILEGE 1
GRANT OBJECT PRIVILEGE 1
GRANT OPTION 1
GRANT SYSTEM PRIVILEGE 1
GROUP BY 1
group ident 1
GROUP idents 1
group membership 1

H

handlers
declaring 1
HAVING 1
host identifiers 1
host variable declarations 1

I

IDENT
privilege 1
ident 1, 2
changing password 1
creating 1
disconnecting from a database 1
dropping 1
GROUP 1
group 1
group membership 1
OS_USER 1, 2
PROGRAM 1
program 1
USER 1
user 1
IDENT privilege 1
identifiers
host 1
standard compliance 1
IF 1
IN predicate 1
INCLUDE SQLCA 1
index 1
indexes 1
indexing
automatic 1
indicator variables 1
inner joins 1
INSERT 1
privilege 1
INTEGER data type 1
integer literals 1
intermediate result sets 1
INTERVAL 1
INTERVAL data types 1
Interval literals 1
invoking procedures 1
IRAND 1
ISO/IEC 9075 1
isolation levels 1
item descriptor area 1
iterative execution
LOOP 1
REPEAT 1
WHILE 1

J

JOIN
standard compliance 1
join ON 1
join USING 1
Joined Tables 1

K

keywords
in syntax diagrams 1

L

labels in SELECT clause 1
LEAVE 1
LEAVE (program ident) 1
left outer joins 1
LIKE 1
limits 1
literals 1
standard compliance 1
LOCALTIME 1
LOCALTIMESTAMP 1
LOG option 1
LOOP 1
LOWER 1

M

MASTER 1
MAX 1
MEMBER privilege 1
meta-characters 1
Mimer SQL
basic concepts 1
database objects 1
relational database 1
MIN 1
MOD 1
modules 1, 2
creating 1

N

natural join 1
NEXT_VALUE 1
NOT EXISTS 1
NOT FOUND 1
NULL 1, 2
in comparisons 1
in expressions 1
in host variables 1
in set functions 1
in UNION queries 1
indicator variables 1
predicate 1
testing for 1
transaction control option 1
NULLIF 1
numerical assignments 1
numerical comparisons 1
numerical data
precision and scale 1
numerical literals 1
numerical strings 1

O

object privileges 1, 2
revoking 1
OCTET_LENGTH 1
OPEN 1
operators 1
alternative forms 1
standard compliance 1, 2
ORDER BY 1
orientation specification 1
OS_USER ident 1
OS_USER idents 1
outer joins 1
outer references 1
overflow
error 1
in expressions 1

P

padding
string values 1
with blanks in LIKE predicate 1
parameter markers
data types 1
in dynamic SQL statements 1
parameters
in syntax diagrams 1
parts explosion problem 1
password 1
PASTE 1
POSITION 1
precedence
expressions 1
search conditions 1
precision 1
predicate
ALL 1
ANY or SOME 1
basic 1
quantified 1
predicates 1
standard compliance 1, 2
syntax 1
PREPARE 1
PRIMARY KEY 1
primary keys 1
primary keys and indexes 1
privileges 1
about 1
access 1, 2
granting
access privileges 1
object privileges 1
system privileges 1
IDENT 1
object 1, 2
revoking
access privileges 1
object privileges 1
system privileges 1
system 1, 2
procedure 1
creating 1
leaving 1
procedure control statements 1
procedure variables
value assignment 1
procedure_variable 1
procedures 1
access-clause 1, 2, 3
calling 1
returning result set data 1
PRODUCT 1
program ident 1
PROGRAM idents 1
program idents
entering 1
EXECUTE privilege 1
leaving 1
retaining resources 1

Q

quantified predicate 1
quantifiers 1

R

read-only result sets 1
REAL data type 1
REFERENCES privilege 1
referential integrity 1
relational operators 1
RELEASE 1
REOPENABLE 1, 2
REOPENABLE cursors 1
REPEAT 1, 2
REPLACE 1
reserved words 1, 2, 3
RESIGNAL 1
RESTRICT 1, 2, 3, 4
RETAIN 1
retrieving single rows 1
RETURN 1
REVOKE ACCESS PRIVILEGE 1
REVOKE OBJECT PRIVILEGE 1
REVOKE SYSTEM PRIVILEGE 1
revoking privileges
recursive effects 1, 2
right outer joins 1
ROLLBACK 1
ROUND 1
routines 1
ROW data type 1

S

scalar functions
list of 1
standard compliance 1
scale 1
schema 1, 2
creating 1
schemas
dropping 1
SCROLL 1, 2
scrollable cursor 1, 2, 3
search conditions 1
precedence 1
truth tables 1
searched CASE 1
secondary index 1
creating 1
dropping 1
maintaining 1
use 1
SELECT 1
FOR UPDATE OF 1
ORDER BY 1
UNION 1
SELECT * 1
SELECT clause 1
SELECT INTO 1
SELECT privilege 1
SELECT statement 1
in dynamic SQL 1
separator 1
sequence 1
creating 1
sequences 1
SESSION_USER 1
SET 1
SET CONNECTION 1
SET DATABANK 1
SET DATABASE 1
SET DESCRIPTOR 1
set functions 1
empty operand set 1
precision and scale 1
restrictions 1
standard compliance 1, 2
SET SESSION 1
SET SHADOW 1
SET TRANSACTION
access mode 1
CHANGES 1
ISOLATION LEVEL 1
START 1
set-function - definition 1
shadow 1
shadow databank
changing 1
creating 1
shadow databank name 1
shadow databanks
dropping 1
shadow file extension 1
SHADOW privilege 1
shadows 1
SIGN 1
SIGNAL 1
simple CASE 1
single-row SELECT 1
SMALLINT data type 1
SOME 1
sort order
character set 1
in SELECT 1
index 1
SOUNDEX 1
specifying default values 1
SQL 1
access control statements 1
connection statements 1
data definition statements 1
data manipulation statements 1
declarative statements 1
diagnostics statements 1
dynamic statements 1
embedded control statements 1
procedure control statements 1
standards 1
limits 1
system administration statements 1
transaction control statements 1
SQL descriptor area 1
allocate 1
COUNT field 1, 2, 3
deallocate 1
get values 1
item descriptor area 1
set values 1
setting the TYPE field 1
TYPE field 1
SQL statements
descriptions 1
groups 1
syntax 1
SQL/PSM 1
SQLDA 1, 2
in FETCH statements 1
in OPEN 1
in PREPARE 1
SQLERROR 1
SQLSTATE 1
fields 1
list of values 1
SQLWARNING 1
standard compliance
assigning values 1, 2
CASE expression 1
CAST specification 1
data types 1
expressions 1
fixed values 1
identifiers 1
JOIN 1
literals 1
operators 1, 2
predicates 1, 2
scalar functions 1
set functions 1, 2
statements ( also see individual statements) 1
subselect 1
START 1
statements
access control 1
connection 1
data definition 1
data manipulation 1
declarative 1
diagnostics 1
dynamic SQL 1
embedded SQL control 1
procedure control 1
system administration 1
transaction control 1
STATISTICS privilege 1
status 1
string
character 1
comparisons 1
concatenation 1
empty 1
expressions 1
hexadecimal 1
literals 1
operators 1
subselect
FROM clause 1
GROUP BY clause 1
HAVING clause 1
in EXISTS predicate 1
in IN predicate 1
in INSERT 1
in UNION queries 1
in view definition 1
SELECT clause 1
standard compliance 1
syntax 1
WHERE clause 1
SUBSTRING 1
SUM 1
synonym 1
creating 1
synonyms 1
dropping 1
syntax diagrams
explanation 1
keywords 1
system administration statements 1
system databanks 1
system privileges 1, 2
granting 1
revoking 1

T

table 1, 2
adding columns 1
base 1
changing column defaults 1
changing definition 1
creating 1
deleting rows 1
inserting rows 1
reference 1
updating contents 1
TAIL 1
target_variables 1
TIME 1
TIMESTAMP 1
TRANS option 1
transaction control statements 1
transactions
aborting 1
CHANGES setting 1
committing 1
conflict 1
control options 1, 2
default settings 1
isolation levels 1
read only 1
read write 1
rollback 1
START setting 1
starting 1
trigger 1
creating 1
triggers 1
TRIM 1
TRUNCATE 1
truncating decimal values 1
truncating string values 1
truth tables 1, 2

U

unary operators 1
undefined values 1
UNION 1
UNIQUE index 1
updatable result sets 1
updatable views 1
UPDATE 1
UPDATE CURRENT 1
UPDATE privilege 1
UPDATE STATISTICS 1
UPPER 1
usage modes 1
embedded 1
interactive 1
JDBC 1
ODBC 1
procedural 1
user databanks 1
specifying location 1
user ident 1
USER idents 1

V

value specification 1
VARCHAR data type 1
variables
declaring 1
value assignment 1
VENDOR 1
vendor-specific SQL 1
view 1
creating 1
views 1
CHECK OPTION 1
column names 1
dropping 1, 2
inserting rows 1

W

WEEK 1
WHENEVER 1
WHILE 1
white-space 1
wildcards 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
Mimer SQL Reference Manual TOC PREV NEXT INDEX