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

access clause for routines 1
access rights 1
for cursors 1
access rights and routines 1
accessing data 1
active connection 1
ALLOCATE DESCRIPTOR 1
arrays 1
assignment - SET statement 1

B

back-up protection 1
BEGIN DECLARE SECTION 1
BSQL 1

C

C (programming language)
comments 1
data types 1
host variables 1
line continuation 1
null terminated strings 1
preprocessor output 1
statement delimiters 1
C/C++ 1
CALL statement 1
calling procedures 1
CASE statement 1
closing cursors 1
COBOL 1
comments 1
data types 1
host variables 1
line continuation 1
preprocessor output 1
statement delimiters 1
comments 1
in C 1
in COBOL 1
in FORTRAN 1
in routines 1
COMMIT 1
committing transactions 1
compiler 1
compound sql statement 1
concurrency control 1
condition names 1
conditional execution - CASE statement 1
conditional execution - IF statement 1
connecting to a database 1
connection name 1
connections
and transactions 1
cursors 1
continue handlers 1
current row 1
cursor-independent data manipulation 1
cursors 1, 2
access rights 1
and program idents 1
closing 1
declaration 1
declaring 1
declaring in PSM 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
in routines 1
in transactions 1
opening 1
position in result set 1, 2
resource allocation 1
restrictions on use in PSM 1
stacking 1
updatable 1
updating and deleting with 1

D

data
errors 1
data types
in C 1
in COBOL 1
in FORTRAN 1
databank
access errors 1
options 1
database
concept 1
connecting to 1
deadlock 1
DEALLOCATE DESCRIPTOR 1
debugging 1
declaration of SQLSTATE 1
DECLARE SECTION 1
declaring condition names 1
declaring cursors 1
declaring exception handlers in routines 1
declaring host variables 1
declaring routine parameters 1
declaring routine variables 1
DELETE 1
delimiters
in C 1
deprecated features 1
parameter markers 1
SET TRANSACTION CHANGES 1
SQLCODE 1
SQLDA 1
VARCHAR(size) 1
DESCRIBE INPUT 1
designing transactions 1
deterministic clause for routines 1
diagnostics area 1
disconnecting 1
disk crash 1
dormant cursors 1
drop and revoke involving routines 1
dynamic SQL 1, 2
cursors 1
describing input variables 1
describing output variables 1
describing statements 1
example framework 1
executing statements 1
object form of statements 1
preparing statements 1
source form of statements 1
statement object form 1
statement source form 1
statements 1
dynamic SQL program example 1

E

Embedded SQL
ESQL 1
host languages 1
program structure 1
restrictions on host language code 1
scope 1
statements 1
END DECLARE SECTION 1
ENTER 1
error handling 1
in transactions 1
exception conditions 1
exception handlers 1
EXEC SQL 1
EXECUTE on routine 1
exit handlers 1

F

FETCH 1, 2
FORTRAN 1
comments 1
host variables 1
line continuation 1
preprocessor output 1
statement delimiters 1
statement margins 1
statement numbers 1
functions
invoking 1

G

general exception handlers 1
GET DIAGNOSTICS 1, 2
GRANT OPTION 1
group idents 1

H

handlers 1
Host Language Dependent Apects 1
host language included code 1
host languages 1
host variables 1
arrays 1
declaration 1, 2
declarations 1
in C 1
in COBOL 1
in cursor declarations 1
in dynamic SQL 1
in FORTRAN 1
in SQL statements 1
names 1

I

ident 1
IDENT privilege 1
identifying SQL statements 1
IF statement 1
implicit connection 1
included code
host language 1
indicator variables 1
INSERT 1
interactive environments 1
internal Mimer SQL return codes 1
interrupted transactions 1
invoking functions 1
invoking procedures 1
ISOLATION LEVEL's in transactions 1
Iteration
LOOP statement 1
REPEAT statement 1
WHILE statement 1

J

Java 1
JDBC 1, 2
join retrievals
using cursors 1

L

LEAVE 1
LEAVE RETAIN 1
LEAVE statement 1
limits 1
line continuation
in C 1
in COBOL 1
in FORTRAN 1
locking 1
LOG databank option 1
logging 1
LOOP statement 1
loops 1

M

managing exception conditions in routines 1
Mimer SQL 1
BSQL 1
Embedded SQL 1
interfaces 1
JDBC 1
ODBC 1
publications 1
minus sign
in COBOL variable names 1
modules 1
multiple connections 1
multiple tables in data retrieval 1

N

NULL 1
NULL databank option 1
null terminated strings 1

O

ODBC 1
OPEN 1, 2
optimistic concurrency control 1
optimization 1
optimizing transactions 1
OS_USER idents 1

P

parameter markers 1
in SELECT statements 1
parameters in routines 1
Parts explosion 1
Persistent Stored Modules 1
platforms 1
positioning cursors 1
preprocessing 1
WHENEVER statements 1
preprocessor output
in C 1
in COBOL 1
in FORTRAN 1
privileges 1
procedures
invoking 1
returning result sets 1
program construction errors 1
program examples 1
program idents 1, 2
program structure 1
PSM 1
PSM Debugger 1

Q

quotation marks
in C 1

R

RDBMS 1
READ ONLY transactions 1
READ WRITE transactions 1
read-only cursors 1, 2
read-set 1
REPEAT statement 1
RESIGNAL statement 1
resignaling exceptions in routines 1
result set procedure CALL 1
result set procedures 1
retrieving data 1
retrieving single rows 1
RETURN statement 1
revoke and drop involving routines 1
ROLLBACK 1
routines
access clause 1
access rights 1
beware using drop and revoke 1
comments in 1
declaring
condition names 1
cursors 1
exception handlers 1
variables 1
deterministic clause 1
invoking 1
managing exception conditions 1
parameters 1
restrictions 1
scope 1
scope in 1
SQL constructs in 1
run-time errors 1

S

SCROLL 1
scrollable cursor 1
SELECT INTO 1
SELECT statement 1
semantic errors 1
SET statement 1
SET TRANSACTION 1
SIGNAL statement 1
signaling exceptions in routines 1
single row SELECT 1
specific exception handlers 1
SQL
compiler 1
constructs in routines 1
descriptor area 1, 2
COUNT field 1
structure 1
dynamic 1
statement identifier 1
statements 1
errors 1
using host variables 1
SQLSTATE 1, 2, 3
class 1
fields 1
return codes 1
subclass 1
stacking cursors 1
starting transactions 1
statement delimiters
in C 1
in COBOL 1
in FORTRAN 1
statement margins
in FORTRAN 1
statement numbers in FORTRAN 1
statements 1
stored procedures and functions 1
stored routines and modules (PSM) 1
subprogram names 1
subroutine names 1
syntax errors 1
system failure 1

T

table access errors 1
tables
entering data 1
TRANS databank option 1
transaction consistency - ISOLATION LEVEL 1
transactions 1
and cursors 1
build-up 1
COMMIT 1
design 1
diagnostics size 1
ending 1
error handling 1
interrupted 1
optimization 1
ROLLBACK 1
with loops 1
tree structure
traversing 1
types 1

U

UPDATE 1
UPDATE CURRENT 1
USAGE ON DOMAIN privilege 1

V

variables
declaring 1
host 1

W

warnings 1
WHENEVER 1
in transactions 1
WHILE statement 1
white-space 1, 2, 3
write-set 1


Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Programmer's Manual TOC PREV NEXT INDEX