Index

A  C  D  E  F  G  H  I  L  M  N  O  P  R  S  T  U  V 

A

accessing Adabas data, 2.1
Adabas data, accessing, 2.1
Adabas, exporting metadata, 2.1.1
ADD
atomic data types, A.1
scaled data types, A.2
advanced data dictionary
See ADD
ALTER statement, B.1
arithmetic operators, B.2.2.1
array handling
normalized tables, 3.4.1
overview, 3.1
sequential flattening, 3.4.2
setting default, 4.1
setting policy, 4
table settings, 4.2

C

case sensitivity, databases, 2.2.2.2
commands
COMMIT, 2.4.1.4
ROLLBACK, 2.4.1.4
commands, passing to database, 2.4.1.5
COMMIT command, restrictions, 2.4.1.4
comparison operators, B.2.2.2
CONCAT operator, 2.4.1.2
conversion, data types, 2.2.3.2, A.1
CREATE statement, B.1
cursor loops, restrictions, 2.4.1.4

D

data definition language, B.1
data dictionary views, 2.4.1.9
data dictionary, views, C.1.2
data types
ADD atomic, A.1
ADD scaled, A.2
conversion, 2.2.3.2, A.1
FLOAT, 2.4.1.7
VARBINARY, 2.4.1.8
data, accessing, 2.1
data, non-relational, 3.1
databases, passing commands, 2.4.1.5
DDL
See data definition language
default, array handling, 4.1
DELETE statement, B.1.1, B.2.1
DROP statement, B.1

E

encrypted format login, 2.4.1.8
errors
ORA-02070, 2.4.1.3, 2.4.1.3, B.2.1
ORA-1002, 2.4.1.4
ORA-28506, C.1.2
ORA-6550, 2.4.1.2
exporting Adabas metadata, 2.1.1

F

FLOAT data type, 2.4.1.7
format login, encrypted, 2.4.1.8
functions, B.2.2.3, B.2.2.4
functions, unsupported, 2.4.1.1

G

gateways
data dictionary tables, C.1
functions, B
pass-through feature, 2.2.1
restrictions, 2.4
SQL restrictions, 2.4.1
SQL syntax, 2.2, B.1
GRANT statement, B.1
group functions, B.2.2.3

H

handling arrays
normalized tables, 3.4.1
overview, 3.1
sequential flattening, 3.4.2
hexadecimal notation, 2.2.3.1

I

INSERT statement, B.1.2, B.2.1

L

locking, database, 2.2.5
login, encrypted format, 2.4.1.8

M

metadata
exporting, 2.1.1
representing, 3.3

N

naming rules, objects, 2.2.2.1
non-relational data, normalizing, 3.1
normalizing non-relation data, 3.1
notation, hexadecimal, 2.2.3.1

O

objects, naming rules, 2.2.2.1
ORA-02070 error, 2.4.1.3, 2.4.1.3, B.2.1
ORA-1002 error, 2.4.1.4
ORA-28506 error, C.1.2
ORA-6550 error, 2.4.1.2

P

passing commands to database, 2.4.1.5
pass-through feature, 2.2.1
PL/SQL, 2.4.1.9
policy, array handling, 4
Predict metatada, 2.1.1

R

representing metadata, 3.3
restrictions
COMMIT command, 2.4.1.4
cursor loops, 2.4.1.4
gateways, 2.4
ROLLBACK command, 2.4.1.4
SQL, 2.4.1
ROLLBACK command, restrictions, 2.4.1.4
ROWID, 2.4.1.2

S

savepoint support, 2.4.1.3
SELECT statement, B.1.3, C.1.1
sequential flattening, 3.4.2
sequential view, 3.4.2
single table, 3.4.2
SQL execution, 2.2.4
SQL functions, unsupported, 2.4.1.1
SQL support, 2.2
SQL syntax, supported, 2.2, B.1
statements
DELETE, B.1.1
DROP, B.1
GRANT, B.1
INSERT, B.1.2, B.2.1
SELECT, B.1.3
UPDATE, B.1.4
string functions, B.2.2.4, B.2.2.4
support, SQL, 2.2

T

transaction, 2.4.1.3
TRUNCATE statement, B.1

U

unsupported SQL functions, 2.4.1.1
UPDATE statement, B.1.4, B.2.1

V

VARBINARY data type, 2.4.1.8
views, data dictionary, 2.4.1.9