Index

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

A

accessing VSAM data, 2.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, 3.4.1
overview, 3.1
sequential flattening, 3.4.2
setting default, 4.1
setting policy, 4
table settings, 4.3

C

case rules, 2.2.3.2
commands, passing to database, 2.4.1.6
COMMIT, restrictions, 2.4.1.5
Comparison operators, B.2.2.2
CONCAT operator, 2.4.1.2
CREATE statement, B.1
cursor loops, restrictions, 2.4.1.5

D

data definition language, B.1
data dictionary tables, C.1
data dictionary views, 2.4.1.10
data dictionary, views, C.1.2
data source restrictions, 2.4.2
data types
ADD atomic data types, A.1
ADD decimal, A.3
ADD non-atomic, A.2
ADD scaled, A.4
conversion, 2.2.4.2
FLOAT, 2.4.1.8
VARBINARY, 2.4.1.8, 2.4.1.9
data, accessing, 2.1
data, non-relational, 3.1
database, locking, 2.2.6
databases, passing commands, 2.4.1.6
decimal data, packed, A.3
default, array handling, 4.1
DELETE statement, B.1.1, B.2.1
DROP statement, B.1

E

encrypted format login, 2.4.1.9
errors
ORA-02070, 2.4.1.3, 2.4.1.3, B.2.1
ORA-1002, 2.4.1.5
ORA-28506, C.1.2
ORA-6550, 2.4.1.2

F

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

G

gateways
data dictionary tables, C.1
pass-through feature, 2.2.2
restrictions, 2.4
SQL restrictions, 2.4.1
supported functions, B
supported 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.4.1

I

import, array handling behavior, 4.2
INSERT statement, B.1.2, B.2.1

L

locking, database, 2.2.6

M

metadata
array handling behavior, 4.2
representing, 3.3

N

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

O

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

P

packed decimal data, ADD, A.3
passing commands to database, 2.4.1.6
pass-through feature, 2.2.2
PL/SQL, 2.4.1.10
policy, array handling, 4

R

representing metadata, 3.3
restrictions
COMMIT, 2.4.1.5
data source, 2.4.2
gateways, 2.4
ROLLBACK, 2.4.1.5
SQL, 2.4.1
ROLLBACK, restrictions, 2.4.1.5
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.5
SQL functions, unsupported, 2.4.1.1
SQL syntax, supported, 2.2, B.1
statements
ALTER, B.1
CREATE, B.1
DROP, B.1
GRANT, B.1
SELECT, B.1.3
select, C.1.1
UPDATE, B.1.4
string functions, B.2.2.4

T

transaction
capability, 2.4.1.3
integrity, 2.4.1.4
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, 2.4.1.9
views, data dictionary, 2.4.1.10
VSAM data, accessing, 2.1