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

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 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

import, array handling behavior, 4.2

INSERT statement, B.1.2, B.2.1

L

locking, database, 2.2.5

login, encrypted format, 2.4.1.8

M

metadata

array handling behavior, 4.2

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