Oracle Transparent Gateway Administrator's Guide -- Index

||, 3-19

ALTER statement, B-1

Arithmetic operators, B-3

BINARY data type, A-1

BIT data type, A-1

Case rules, 3-9

Case studies, 4-1

Chained mode, 3-8

CHAR data type, A-1

COMMIT

restrictions, 3-13

Commit point site, 3-13

Comparison operators, B-3

CONCAT operator, 3-19

Configuring

two-phase commit, 2-12

Configuring the gateway, 2-1

CONNECT BY clause, 3-15

COPY command, 3-16

CREATE statement, B-1

Creating

transaction log table, 2-13

Cursor loops

restrictions, 3-13

Data definition language, B-1

Data dictionary

views, C-2

Data type

BINARY, A-1

BIT, A-1

CHAR, A-1

conversion, 3-10

DATE, A-1

DATETIME, A-1

DECIMAL, A-1

DOUBLE PRECISION, A-1

FLOAT, A-1

FLOAT data type, 3-17

IMAGE, A-1

INTEGER, A-1

LONG, A-2

LONG RAW, A-1

MONEY, A-1

NCHAR, A-1

NUMBER, A-1

NUMERIC, A-1

NVARCHAR, A-1

RAW, A-1

REAL, A-2

SMALL DATETIME, A-2

SMALL MONEY, A-2

SMALLINT, A-2

TEXT, A-2

TINYINT, A-2

VARBINARY, 3-17, A-2

VARCHAR, A-2

VARCHAR2, A-2

Database link

behavior, 2-7

DATE data type, A-1

DATETIME data type, A-1

DDL statement, 3-14

DECIMAL data type, A-1

DELETE statement, 4-7, B-1, B-2

Demo build SQL script, 4-2

Demonstration files, 4-2

Demonstration tables, 4-3

Demonstration tables build SQL script, 4-3

DOUBLE PRECISION data type, A-1

DROP statement, B-1

Encrypted format login, 3-17

Error messages

error tracing, D-6

Errors

ORA-02070, 3-13

Executing Stored Procedures, 4-8

FLOAT data type, A-1

Functions in SQL, 3-2

Gateway

case studies, 4-1

data dictionary tables, C-1

default SID, 2-1

pass-through feature, 3-1

supported functions, B-1

supported SQL syntax, B-1

system identifier (SID), 2-1

two-phase commit, 2-12

GRANT statement, B-1

Group functions, B-4

Hexadecimal notation, 3-10

HS_FDS_CONNECT_INFO initialization parameter, D-3

HS_FDS_DEFAULT_OWNER initialization parameter, 2-14, D-4

HS_FDS_PROC_IS_FUNC initialization parameter, D-4

HS_FDS_RECOVERY_ACCOUNT initialization parameter, D-4

HS_FDS_RECOVERY_PWD initialization parameter, D-5

HS_FDS_RESULTSET_SUPPORT initialization parameter, D-5

HS_FDS_TRACE_LEVEL initialization parameter, D-5

HS_FDS_TRANSACTION_LOG initialization parameter, D-6

HS_FDS_TRANSACTION_MODEL initialization parameter, D-6

HS_TRANSACTION_LOG, 2-13

IMAGE data type, A-1

Initialization parameter file

customizing, 2-2, D-1

initsid.ora file, 2-2, D-2

INSERT statement, 3-15, 4-7, B-1, B-2

INTEGER data type, A-1

Known restrictions, 3-12

listener.ora file, 2-9

example, 2-4

location, 2-3

Locking, database, 3-12

LONG data type, A-2

LONG RAW data type, A-1

MONEY data type, A-1

NCHAR data type, A-1

NULL values, 3-8

NUMBER data type, A-1

NUMERIC data type, A-1

NVARCHAR data type, A-1

NVL function, 4-6

Objects, naming rules, 3-8

ORA-02070, 3-13

Oracle Net Services

configuring, 2-3

Passing commands to database, 3-14

Pass-Through Feature, 4-7

Pass-through feature, 3-14

PL/SQL, 3-19

RAW data type, A-1

REAL data type, A-2

RECOVERY_ACCOUNT

account username, 2-12

creating a recovery account, 2-12

ROLLBACK

restrictions, 3-13

ROWID, 3-15

savepoint support, 3-13

SELECT statement, 4-8, B-2, C-1

SID, 2-1

SMALL DATETIME data type, A-2

SMALLINT data type, A-2

Specifying an Owner, 2-14

Stored procedures, 3-14, 3-19

running in chained mode, 3-8

Stored procedures in SQL Server, 3-2

String functions, B-4

SUM function, 4-6

TEXT data type, A-2

TINYINT data type, A-2

TNS listener

configuring for gateway, 2-3

starting, 2-5

Transaction log table

creating, 2-13

Transaction modes, 3-8

transactional capability, 3-13

transactional integrity, 3-13

TRUNCATE statement, B-1

Two-phase commit, 3-13

configuration, 2-12

transaction log table, 2-13

UPDATE statement, 3-15, 4-7, 4-8, B-2

VARBINARY data type, 3-17, A-2

VARCHAR data type, A-2

VARCHAR2 data type, A-2

WHERE CURRENT OF clause, 3-15

Index

Symbols

A

B

C

D

E

F

G

H

I

K

L

M

N

O

P

R

S

T

U

V

W