Index

A  B  C  D  E  F  G  H  I  K  L  M  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, A.1

C

Case rules, 2.6.2.3
Case studies, 3
case1.sql, 3.3
CHAR data type, A.1
character sets
Heterogeneous Services, D.3.5.1
COMMIT
restrictions, 2.7.3
Commit point site, 2.7.2
Comparison operators, B.2.2.2
CONNECT BY clause, 2.7.6.2
CREATE statement, B.1
Cursor loops
restrictions, 2.7.3

D

Data definition language, B.1
Data dictionary
views, C.1.4
Data type
BYTE, A.1, A.1
CHAR, A.1
conversion, 2.6.3.2
DATETIME, A.1
DECIMAL, A.1
FLOAT, A.1
INTEGER, A.1
LONG, A.1
LONG RAW, A.1, A.1
MONEY, A.1
NCHAR, A.1
NVARCHAR, A.1
SERIAL, A.1, A.1
SMALLFLOAT, A.1
TEXT, A.1
VARCHAR, A.1, A.1
VARCHAR2, A.1, A.1
Date functions, B.2.2.6
DATETIME data type, A.1
DECIMAL data type, A.1
DELETE statement, 3.9.1, B.1.1, B.2.1
restrictions on use, 2.7.6.5
Demo 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.8.1
Error messages
error tracing, D.3.16
Errors
ORA-02070, 2.7.2

F

fetch array size, with HS_FDS_FETCH_ROWS, D.3.18
FLOAT data type, 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.6.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_FETCH_ROWS parameter, D.3.18
HS_FDS_TRACE_LEVEL initialization parameter, D.3.16
enabling agent tracing, D.1
HS_FDS_TRANSACTION_LOG initialization parameter, D.3.17
HS_IDLE_TIMEOUT initialization parameter, D.3.19
HS_KEEP_REMOTE_COLUMN_SIZE initialization parameter, D.3.21
HS_LANGUAGE initialization parameter, D.3.5
HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, D.3.6
HS_NLS_LENGTH_SEMANTICS initialization parameter, D.3.20
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
restrictions on use, 2.7.6.4, 2.7.6.5
INTEGER data type, A.1

K

Known restrictions, 2.7

L

Locking, database, 2.6.5
LONG data type, A.1
LONG RAW data type, A.1, A.1

M

MONEY data type, A.1

N

NCHAR data type, A.1
NVARCHAR data type, A.1
NVL function, 3.7

O

Objects
valid characters, 2.6.2.2
Objects, naming rules, 2.6.2.1
ORA-02070, 2.7.2
Oracle functions
TO_DATE, B.2.3

P

parameters
gateway initialization file
HS_FDS_FETCH_ROWS, D.3.18
Passing commands to database, 2.7.4
Pass-Through Feature, 3.11
Pattern matching, B.2.2.5
PL/SQL, 2.8.3, 2.8.4

R

RAW data type, 2.6.3.1
REAL data type, 2.7.5
ROLLBACK
restrictions, 2.7.3
ROWID, 2.7.6.1, 2.7.6.6

S

savepoint support, 2.7.2
SELECT statement, 3.11.2, B.1.3, C.1.2
use of NULL keyword, 2.7.6.3
SERIAL data type, A.1, A.1
Set operations, B.2.2.5
SMALLFLOAT data type, 2.7.5, A.1
Stored procedures, 2.7.10
String functions, B.2.2.4
SUM function, 3.7

T

TEXT data type, A.1
TO_DATE function, B.2.3
transactional capability, 2.7.2
transactional integrity, 2.7.1
TRUNCATE statement, B.1
Two-phase commit, 2.7.2

U

UPDATE statement, 3.9.2, 3.11.1, B.1.4, B.2.1
restrictions on use, 2.7.6.5

V

VARCHAR data type, A.1, A.1
VARCHAR2 data type, A.1, A.1

W

WHERE CURRENT OF clause, 2.7.6.1