Skip Headers

Oracle® Transparent Gateway for Microsoft SQL Server Administrator's Guide
10g Release 1 (10.1) for Microsoft Windows

Part Number B10544-01
Go To Table Of Contents
Contents

Go to previous page

Index

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


Symbols

||, 3-22

A

ALTER statement, B-1
Arithmetic operators, B-3

B

BINARY data type, A-1
BIT data type, A-1

C

Case rules, 3-9
Case studies, 4-1
Chained mode, 3-8
CHAR data type, A-1
COMMIT
restrictions, 3-15
Comparison operators, B-3
CONCAT operator, 3-22
Configuring
two-phase commit, 2-12
Configuring the gateway, 2-1
CONNECT BY clause, 3-17
COPY command, 3-18
CREATE statement, B-1
Creating
transaction log table, 2-13
Cursor loops
restrictions, 3-15

D

Data definition language, B-1
Data dictionary
views, C-2
Data type
BINARY, A-1
BIT, A-1
CHAR, A-1
conversion, 3-11
DATE, A-1
DATETIME, A-1
DECIMAL, A-1
FLOAT, A-1
FLOAT data type, 3-19
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-2
NVARCHAR, A-1
RAW, A-1
REAL, A-2
SMALL DATETIME, A-2
SMALL MONEY, A-2
SMALLINT, A-2
TEXT, A-2
TIMESTAMP, A-2
TINYINT, A-2
VARBINARY, 3-19, 3-20, A-2
VARCHAR, A-2
Database link
behavior, 2-7
DATE data type, A-1
DATETIME data type, A-1
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
DROP statement, B-1

E

Encrypted format login, 3-20
Error messages
error tracing, D-5
Errors
ORA-02070, 3-14
Executing Stored Procedures, 4-8

F

FLOAT data type, A-1
Functions in SQL, 3-2

G

Gateway
case studies, 4-1
data dictionary tables, C-1
default SID, 2-1
pass-through feature, 3-1, 3-16
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

H

Hexadecimal notation, 3-11
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

I

IMAGE data type, A-1
Initialization parameter file
customizing, 2-2, D-1
initsid.ora file, 2-2, D-2
INSERT statement, 4-7, B-2
INTEGER data type, A-1

K

Known restrictions, 3-13

L

listener.ora file, 2-9
example, 2-4
location, 2-3
Locking, database, 3-13
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-9
NUMBER data type, A-1
NUMERIC data type, A-2
NVARCHAR data type, A-1
NVL function, 4-6

O

Objects, naming rules, 3-9
ORA-02070, 3-14
Oracle Net Services
configuring, 2-3

P

Passing commands to database, 3-15
Pass-Through Feature, 4-7
Pattern Matching, B-4
PL/SQL, 3-22

R

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-15
ROWID, 3-17, 3-18

S

savepoint support, 3-14
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-15, 3-22
running in chained mode, 3-8
Stored procedures in SQL Server, 3-2
String functions, B-4
SUM function, 4-6

T

TEXT data type, A-2
TIMESTAMP 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-14
transactional integrity, 3-14
TRUNCATE statement, B-1
Two-phase commit, 3-14
configuration, 2-12
transaction log table, 2-13

U

UPDATE statement, 3-17, 3-18, 4-7, 4-8, B-2

V

VARBINARY data type, 3-19, 3-20, A-2
VARCHAR data type, A-2

W

WHERE CURRENT OF clause, 3-17

Go to previous page
Oracle
Copyright © 2002, 2004, Oracle.

All rights reserved.
Go To Table Of Contents
Contents