Index

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

A

accessing IMS data, 3.1
ADD
atomic data types, A.1
decimal data types, A.3
non-atomic data types, A.2
scaled data types, A.4
advanced data dictionary
See ADD
ALTER statement, B.1
arithmetic operators, B.2.2.1
array handling
modifying default, 4.2
normalized tables, 2.4.1
overview, 2.1
sequential flattening, 2.4.2
setting default, 4.1
setting policy, 4
table settings, 4.3

C

case rules, 3.2.1.2
column names, 3.6.1.6
column names, restrictions, 3.6.1.6
commands, passing to database, 3.6.1.5
comparison operators, B.2.2.2
CREATE statement, B.1

D

data definition language, B.1
data dictionary
tables, C.1
views, C.1.2
data types
ADD atomic, A.1
ADD decimal, A.3
ADD non-atomic, A.2
ADD scaled, A.4
data, accessing, 3.1
data, non-relational, 2.1
databases, passing commands, 3.6.1.5
DDL
See data definition language
decimal data, packed, A.3
default, array handling, 4.1
DELETE statement, B.1.1, B.2.1
DROP statement, B.1

E

errors
ORA-00972, 3.6.1.6, 3.6.1.6
ORA-02070, 3.6.1.3, 3.6.1.3, B.2.1
ORA-28506, C.1.2

F

functions, B.2.2.3, B.2.2.4, B.2.2.4
functions, unsupported, 3.6.1.1

G

gateways
data dictionary tables, C.1
functions, B
restrictions, 3.6
SQL restrictions, 3.6.1
SQL syntax, 3.2, B.1
GRANT statement, B.1
group functions, B.2.2.3

H

handling arrays
normalized tables, 2.4.1
overview, 2.1
sequential flattening, 2.4.2

I

import, array handling behavior, 4.2
IMS data, accessing, 3.1
INSERT statement, B.1.2, B.2.1

M

metadata
array handling behavior, 4.2
representing, 2.3

N

names, tables and columns, 3.6.1.6
naming rules, objects, 3.2.1.1
non-relational data, normalizing, 2.1
normalizing non-relation data, 2.1

O

objects, naming rules, 3.2.1.1
ORA-000972 error, 3.6.1.6
ORA-00972 error, 3.6.1.6
ORA-02070 error, 3.6.1.3, 3.6.1.3, B.2.1
ORA-28506 error, C.1.2

P

packed decimal data, ADD, A.3
passing commands to database, 3.6.1.5
policy, array handling, 4

R

representing metadata, 2.3
restrictions, 3.6.1.6
gateways, 3.6
SQL, 3.6.1

S

savepoint support, 3.6.1.3
SELECT statement, B.1.3, C.1.1
sequential flattening, 2.4.2
sequential view, 2.4.2
single table, 2.4.2
SQL functions, unsupported, 3.6.1.1
SQL syntax, gateways, 3.2, B.1
statements
ALTER, B.1
CREATE, B.1
DELETE, B.1.1
DROP, B.1
GRANT, B.1
INSERT, B.1.2
SELECT, B.1.3, C.1.1
TRUNCATE, B.1
UPDATE, B.1.4
stored procedures, 3.6.1.8
string functions, B.2.2.4, B.2.2.4

T

table names, 3.6.1.6
table names, restrictions, 3.6.1.6
transaction
capability, 3.6.1.3
integrity, 3.6.1.4
TRUNCATE statement, B.1

U

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