Index

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

A

ALTER statement, B.1

Arithmetic operators, B.2.2.1

B

BYTE data type, A.1

BYTEINT data type, A.1

C

Case rules, 2.2.2.2

Case studies, 3

CHAR data type, A.1

character sets

Heterogeneous Services, D.3.5.1

COMMIT

restrictions, 2.3.3

Commit point site, 2.3.2

Comparison operators, B.2.2.2

CONNECT BY clause, 2.3.6.2

COPY command, 2.3.7

CREATE statement, B.1

Cursor loops

restrictions, 2.3.3

D

Data definition language, B.1

Data dictionary

views, C.1.4

Data type

BYTE, A.1

BYTEINT, A.1

CHAR, A.1

conversion, 2.2.3.2

DATE, A.1

DECIMAL, A.1

FLOAT, A.1, A.1

INTEGER, A.1

LONG, A.1, A.1

LONG VARCHAR, A.1, A.1

RAW, A.1

SMALLINT, A.1

TIME, A.1

TIMESTAMP, A.1

VARBINARY, 2.4.1

VARBYTE, A.1, A.1

VARCHAR, A.1, A.1

VARCHAR2, A.1, A.1

DATE data type, A.1

DDL statement, 2.3.4

DECIMAL data type, A.1

DELETE statement, 3.9.1, B.1.1, B.2.1

demonstration build SQL script, 3.3

Demonstration files, 3.3

Demonstration tables, 3.5

Demonstration tables build SQL script, 3.5

describe cache high water mark

definition, D.3.4

DROP statement, B.1

E

Encrypted format login, 2.4.1

Error messages

error tracing, D.3.17

Errors

ORA-02070, 2.3.2

F

fetch array size, with HS_FDS_FETCH_ROWS, D.3.19

FLOAT data type, A.1, A.1

G

Gateway

case studies, 3

data dictionary tables, C.1

pass-through feature, 2.1

supported functions, B

supported SQL syntax, B.1

globalization support

Heterogeneous Services, D.3.5

GRANT statement, B.1

Group functions, B.2.2.3

H

Heterogeneous Services

defining maximum number of open cursors, D.3.7

optimizing data transfer, D.3.8

setting global name, D.3.3

specifying cache high water mark, D.3.4

tuning internal data buffering, D.3.9

tuning LONG data transfer, D.3.6

Hexadecimal notation, 2.2.3.1

HS_DB_NAME initialization parameter, D.3.3

HS_DESCRIBE_CACHE_HWM initialization parameter, D.3.4

HS_FDS_CONNECT_INFO, D.3.13

HS_FDS_DEFAULT_OWNER initialization parameter, D.3.14

HS_FDS_FETCH_ROWS parameter, D.3.19

HS_FDS_TRACE_LEVEL initialization parameter, D.3.17

enabling agent tracing, D.1

HS_FDS_TRANSACTION_LOG initialization parameter, D.3.18

HS_LANGUAGE initialization parameter, D.3.5

HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, D.3.6

HS_OPEN_CURSORS initialization parameter, D.3.7

HS_RPC_FETCH_REBLOCKING initialization parameter, D.3.8

HS_RPC_FETCH_SIZE initialization parameter, D.3.9

HS_TIME_ZONE initialization parameter, D.3.10

I

IFILE initialization parameter, D.3.12

Initialization parameter file

customizing, D

INSERT statement, 3.9.3, B.1.2, B.2.1

INTEGER data type, A.1

K

Known restrictions, 2.3

L

Locking, database, 2.2.5

LONG data type, A.1, A.1

LONG VARCHAR data type, A.1, A.1

N

NVL function, 3.7

O

Objects, naming rules, 2.2.2.1

ORA-02070, 2.3.2

P

parameters

gateway initialization file

HS_FDS_FETCH_ROWS, D.3.19

Passing commands to database, 2.3.4

Pass-Through Feature, 3.11

PL/SQL, 2.4.3, 2.4.4

R

RAW data type, A.1

ROLLBACK

restrictions, 2.3.3

ROWID, 2.3.6.1, 2.3.6.3

S

savepoint support, 2.3.2

SELECT statement, 3.11.2, B.1.3, C.1.2

SMALLINT data type, A.1

Stored procedures, 2.3.9

String functions, B.2.2.4

SUM function, 3.7

T

TIME data type, A.1

TIMESTAMP data type, A.1

transactional capability, 2.3.2

transactional integrity, 2.3.1

TRUNCATE statement, B.1

Two-phase commit, 2.3.2

U

UPDATE statement, 3.9.2, 3.11.1, B.1.4, B.2.1

V

VARBINARY data type, 2.4.1

VARBYTE data type, A.1, A.1

VARCHAR data type, A.1, A.1

VARCHAR2 data type, A.1, A.1

W

WHERE CURRENT OF clause, 2.3.6.1