Index

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

A

accessing IMS 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.1.2

column names, 2.6.1.6

column names, restrictions, 2.6.1.6

commands, passing to database, 2.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, 2.1

data, non-relational, 3.1

databases, passing commands, 2.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, 2.6.1.6, 2.6.1.6

ORA-02070, 2.6.1.3, 2.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, 2.6.1.1

G

gateways

data dictionary tables, C.1

functions, B

restrictions, 2.6

SQL restrictions, 2.6.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

I

import, array handling behavior, 4.2

IMS data, accessing, 2.1

INSERT statement, B.1.2, B.2.1

M

metadata

array handling behavior, 4.2

representing, 3.3

N

names, tables and columns, 2.6.1.6

naming rules, objects, 2.2.1.1

non-relational data, normalizing, 3.1

normalizing non-relation data, 3.1

O

objects, naming rules, 2.2.1.1

ORA-000972 error, 2.6.1.6

ORA-00972 error, 2.6.1.6

ORA-02070 error, 2.6.1.3, 2.6.1.3, B.2.1

ORA-28506 error, C.1.2

P

packed decimal data, ADD, A.3

passing commands to database, 2.6.1.5

policy, array handling, 4

R

representing metadata, 3.3

restrictions, 2.6.1.6

gateways, 2.6

SQL, 2.6.1

S

savepoint support, 2.6.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 functions, unsupported, 2.6.1.1

SQL syntax, gateways, 2.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, 2.6.1.8

string functions, B.2.2.4, B.2.2.4

T

table names, 2.6.1.6

table names, restrictions, 2.6.1.6

transaction

capability, 2.6.1.3

integrity, 2.6.1.4

TRUNCATE statement, B.1

U

unsupported SQL functions, 2.6.1.1

UPDATE statement, B.1.4, B.2.1