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