Skip Headers
Oracle® Transparent Gateway for Microsoft SQL Server Administrator's Guide
10g Release 2 (10.2) for Microsoft Windows (32-bit)

Part Number B14270-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
View PDF

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

BIGINT data type, A.1
BINARY data type, A.1
BIT data type, A.1

C

Case rules, 3.4.3.2
Case studies, 4
Chained mode, 3.4.1
CHAR data type, A.1
COMMIT
restrictions, 3.5.4
Comparison operators, B.2.2.2
CONCAT operator, 3.6.6
Configuring
two-phase commit, 2.7.1
Configuring the gateway, 2.1
CONNECT BY clause, 3.5.8.2
COPY command, 3.5.10
CREATE statement, B.1
Creating
transaction log table, 2.7.1.2
Cursor loops
restrictions, 3.5.4

D

Data definition language, B.1
Data dictionary
views, C.1.4
Data type
BIGINT, A.1
BINARY, A.1
BIT, A.1
CHAR, A.1
conversion, 3.4.4.3
DATE, A.1
DATETIME, A.1
DECIMAL, A.1
FLOAT, A.1
FLOAT data type, 3.6.1
IMAGE, A.1
INTEGER, A.1
LONG, A.1
LONG RAW, A.1
MONEY, A.1
NCHAR, A.1
NTEXT, A.1
NUMBER, A.1
NUMERIC, A.1
NVARCHAR, A.1
RAW, A.1
REAL, A.1
SMALL DATETIME, A.1
SMALL MONEY, A.1
SMALLINT, A.1
TEXT, A.1
TIMESTAMP, A.1
TINYINT, A.1
UNIQUEIDENTIFIER, A.1
VARBINARY, 3.6.2, 3.6.3, A.1
VARCHAR, A.1
Database link
behavior, 2.4
DATE data type, A.1
DATETIME 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
DROP statement, B.1

E

Encrypted format login, 3.6.3
Error messages
error tracing, D.10
Errors
ORA-02070, 3.5.3
Executing Stored Procedures, 4.12

F

FLOAT data type, A.1
Functions in SQL, 3.2

G

Gateway
case studies, 4
data dictionary tables, C.1
default SID, 2.1.1
pass-through feature, 3.1, 3.5.7
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.4

H

Hexadecimal notation, 3.4.4.1
HS_FDS_CONNECT_INFO initialization parameter, D.2
HS_FDS_DEFAULT_OWNER initialization parameter, 2.7.2, D.3
HS_FDS_PARSER_TOKEN_SIZE initialization parameter, D.4
HS_FDS_PROC_IS_FUNC initialization parameter, D.5
HS_FDS_RECOVERY_ACCOUNT initialization parameter, D.6
HS_FDS_RECOVERY_PWD initialization parameter, D.7, D.8
HS_FDS_RESULTSET_SUPPORT initialization parameter, D.9
HS_FDS_TRACE_LEVEL initialization parameter, D.10
HS_FDS_TRANSACTION_LOG initialization parameter, D.11
HS_FDS_TRANSACTION_MODEL initialization parameter, D.12
HS_TRANSACTION_LOG, 2.7.1.2

I

IMAGE data type, A.1
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
INTEGER data type, A.1

K

Known restrictions, 3.5

L

listener.ora file, 2.6.2
example, 2.2.1.2
location, 2.2.1
Locking, database, 3.4.6
LONG data type, A.1
LONG RAW data type, A.1

M

MONEY data type, A.1

N

NCHAR data type, A.1
NTEXT data type, A.1
NULL values, 3.4.2
NUMBER data type, A.1
NUMERIC data type, A.1
NVARCHAR data type, A.1
NVL function, 4.7

O

Objects, naming rules, 3.4.3.1
ORA-02070, 3.5.3
Oracle Net Services
configuring, 2.2

P

Passing commands to database, 3.5.6
Pass-Through Feature, 4.11
Pattern Matching, B.2.2.3
PL/SQL, 3.6.7, 3.6.8

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.5.4
ROWID, 3.5.8.1, 3.5.8.6

S

savepoint support, 3.5.3
SELECT statement, 4.11.2, B.1.3, C.1.2
SID, 2.1.1
SMALL DATETIME data type, A.1
SMALLINT data type, A.1
Specifying an Owner, 2.7.2
Stored procedures, 3.5.5, 3.6.9
running in chained mode, 3.4.1
Stored procedures in SQL Server, 3.2
String functions, B.2.2.5, B.2.2.5
SUM function, 4.7

T

TEXT data type, A.1
TIMESTAMP data type, A.1
TINYINT data type, A.1
TNS listener
configuring for gateway, 2.2.1
starting, 2.2.2
Transaction log table
creating, 2.7.1.2
Transaction modes, 3.4.1
transactional capability, 3.5.3
transactional integrity, 3.5.2
TRUNCATE statement, B.1
Two-phase commit, 3.5.3
configuration, 2.7.1
transaction log table, 2.7.1.2

U

UNIQUEIDENTIFIER data type, A.1
UPDATE statement, 3.5.8.5, 4.9.2, 4.11.1, B.1.4, B.2.1

V

VARBINARY data type, 3.6.2, 3.6.3, A.1
VARCHAR data type, A.1

W

WHERE CURRENT OF clause, 3.5.8.1