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

Master Index

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 DBC1

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