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

Case studies, 4

CHAR data type, A.1

CHARACTER data type, A.1

COMMIT

restrictions, 3.3.3

Commit point site, 3.3.2

Comparison operators, B.2.2.2

Configuring

two-phase commit, 2.7.1

Configuring the gateway, 2.1

CONNECT BY clause, 3.3.6.2

COPY command, 3.3.7

CREATE statement, B.1

Creating

transaction log table, 2.7.1.2

Cursor loops

restrictions, 3.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

CHARACTER, A.1

conversion, 3.2.3.3

DATE, A.1

DEC, A.1

DECIMAL, A.1

DOUBLE PRECISION, A.1

FLOAT, A.1

INT, A.1

INTEGER, A.1

INTERVAL, A.1

LONG, A.1

LONG VARCHAR, A.1

NUMBER, A.1

NUMERIC, A.1

RAW, A.1

REAL, A.1

SMALLINT, A.1

TIME, A.1

TIMESTAMP, A.1

VARBINARY, 3.4.1

VARBYTE, A.1

VARCHAR, A.1

VARCHAR2, A.1

Database link

behavior, 2.4

DATE data type, A.1

DDL statement, 3.3.4

DEC data type, A.1

DECIMAL data type, A.1

DELETE statement, 4.9.1, B.1.1, B.2.1

Demo build SQL script, 4.3

Demonstration files, 4.3

Demonstration tables, 4.5

Demonstration tables build SQL script, 4.5

DOUBLE PRECISION data type, A.1

DROP statement, B.1

E

Encrypted format login, 3.4.1

Error messages

error tracing, D.7

Errors

ORA-02070, 3.3.2

F

FLOAT data type, A.1

G

Gateway

case studies, 4

data dictionary tables, C.1

default SID, 2.1.1

pass-through feature, 3.1

supported functions, B

supported SQL syntax, B.1

system identifier (SID), 2.1.1

two-phase commit, 2.7.1

Gateway Password Encryption Tool, 2.5

GRANT statement, B.1

Group functions, B.2.2.3

H

Hexadecimal notation, 3.2.3.1

HS_FDS_CONNECT_INFO initialization parameter, D.2

HS_FDS_PARSER_TOKEN_SIZE initialization parameter, D.3

HS_FDS_RECOVERY_ACCOUNT initialization parameter, D.4

HS_FDS_RECOVERY_PWD initialization parameter, D.5

HS_FDS_SHAREABLE_NAME initialization parameter, D.6

HS_FDS_TRACE_LEVEL initialization parameter, D.7

HS_FDS_TRANSACTION_LOG initialization parameter, D.8

HS_FDS_TRANSACTION_MODEL initialization parameter, D.9

HS_TRANSACTION_LOG, 2.7.1.2

I

Initialization parameter file

customizing, 2.1.2, D

initsid.ora file, 2.1.2, D

INSERT statement, 4.9.3, B.1.2, B.2.1

INT data type, A.1

INTEGER data type, A.1

INTERVAL data type, A.1

K

Known restrictions, 3.3

L

listener.ora file, 2.6.2

example, 2.2.1.2

location, 2.2.1

Locking, database, 3.2.5

LONG data type, A.1

LONG VARCHAR data type, A.1

N

NUMBER data type, A.1

NUMERIC data type, A.1

NVL function, 4.7

O

Objects, naming rules, 3.2.2.1

ODBC connectivity

specifying path to library, D.6

ORA-02070, 3.3.2

Oracle Net Services

configuring, 2.2

P

Passing commands to database, 3.3.4

Pass-Through Feature, 4.11

PL/SQL, 3.4.3, 3.4.4

R

RAW data type, A.1

REAL data type, A.1

RECOVERY_ACCOUNT

account username, 2.7.1.1

creating a recovery account, 2.7.1.1

ROLLBACK

restrictions, 3.3.3

ROWID, 3.3.6.1, 3.3.6.3

S

savepoint support, 3.3.2

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

SID, 2.1.1

SMALLINT data type, A.1

Stored procedures, 3.3.9

String functions, B.2.2.4

SUM function, 4.7

T

TIME data type, A.1

TIMESTAMP data type, A.1

TNS listener

configuring for gateway, 2.2.1

starting, 2.2.2

Transaction log table

creating, 2.7.1.2

transactional capability, 3.3.2

transactional integrity, 3.3.1

TRUNCATE statement, B.1

Two-phase commit, 3.3.2

configuration, 2.7.1

transaction log table, 2.7.1.2

U

UPDATE statement, 4.9.2, 4.11.1, B.1.4, B.2.1

V

VARBINARY data type, 3.4.1

VARBYTE data type, A.1

VARCHAR data type, A.1

VARCHAR2 data type, A.1

W

WHERE CURRENT OF clause, 3.3.6.1