Skip Headers
Oracle® Database Gateway for SQL Server User's Guide,
11g Release 1 (11.1)

B31049-03
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
PDF · Mobi · ePub

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, 2.4.3.2
Case studies, 3
Chained mode, 2.4.1
CHAR data type, A.1
character sets
Heterogeneous Services, D.3.6.1
COMMIT
restrictions, 2.5.4
Comparison operators, B.2.2.2
CONCAT operator, 2.6.4
CONNECT BY clause, 2.5.8.2
COPY command, 2.5.10
CREATE statement, B.1
Cursor loops
restrictions, 2.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, 2.4.4.3
DATE, A.1
DATETIME, A.1
DECIMAL, A.1
FLOAT, A.1
IMAGE, A.1
LONG RAW, A.1
MONEY, A.1
NCHAR, 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
TIMESTAMP, A.1
TINYINT, A.1
VARBINARY, 2.6.1, A.1
VARCHAR, A.1, A.1
DATE data type, A.1
DATETIME data type, A.1
DECIMAL data type, A.1
DELETE statement, 3.9.1, B.1.1, B.2.1
demonstration 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.5
DROP statement, B.1

E

Encrypted format login, 2.6.1
Error messages
error tracing, D.3.20
Errors
ORA-02070, 2.5.3
Executing Stored Procedures, 3.12

F

fetch array size, with HS_FDS_FETCH_ROWS, D.3.23
FLOAT data type, A.1
Functions in SQL, 2.2

G

Gateway
case studies, 3
data dictionary tables, C.1
pass-through feature, 2.1, 2.5.7
supported functions, B
supported SQL syntax, B.1
globalization support
Heterogeneous Services, D.3.6
GRANT statement, B.1
Group functions, B.2.2.4

H

Heterogeneous Services
defining maximum number of open cursors, D.3.8
optimizing data transfer, D.3.9
setting global name, D.3.4
specifying cache high water mark, D.3.5
tuning internal data buffering, D.3.10
tuning LONG data transfer, D.3.7
Hexadecimal notation, 2.4.4.1
HS_CALL_NAME initialization parameter, D.3.1
HS_DB_NAME initialization parameter, D.3.4
HS_DESCRIBE_CACHE_HWM initialization parameter, D.3.5
HS_FDS_CONNECT_INFO, D.3.14
HS_FDS_DEFAULT_OWNER initialization parameter, D.3.15
HS_FDS_FETCH_ROWS parameter, D.3.23
HS_FDS_PROC_IS_FUNC initialization parameter, D.3.16
HS_FDS_RECOVERY_PWD initialization parameter, D.3.22
HS_FDS_RESULTSET_SUPPORT initialization parameter, D.3.19
HS_FDS_TRACE_LEVEL initialization parameter, D.3.20
enabling agent tracing, D.1
HS_FDS_TRANSACTION_LOG initialization parameter, D.3.21
HS_LANGUAGE initialization parameter, D.3.6
HS_LONG_PIECE_TRANSFER_SIZE initialization parameter, D.3.7
HS_OPEN_CURSORS initialization parameter, D.3.8
HS_RPC_FETCH_REBLOCKING initialization parameter, D.3.9
HS_RPC_FETCH_SIZE initialization parameter, D.3.10
HS_TIME_ZONE initialization parameter, D.3.11

I

IFILE initialization parameter, D.3.13
IMAGE data type, A.1
Initialization parameter file
customizing, D
INSERT statement, 3.9.3, B.1.2, B.2.1

K

Known restrictions, 2.5

L

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

M

MONEY data type, A.1

N

NCHAR data type, A.1
NULL values, 2.4.2
NUMBER data type, A.1
NUMERIC data type, A.1
NVARCHAR data type, A.1
NVL function, 3.7

O

Objects, naming rules, 2.4.3.1
ORA-02070, 2.5.3

P

parameters
gateway initialization file
HS_FDS_FETCH_ROWS, D.3.23
Passing commands to database, 2.5.6
Pass-Through Feature, 3.11
Pattern Matching, B.2.2.3
PL/SQL, 2.6.5, 2.6.6

R

RAW data type, A.1
REAL data type, A.1
remote functions
referenced in SQL statements, D.3.1
ROLLBACK
restrictions, 2.5.4
ROWID, 2.5.8.1, 2.5.8.6

S

savepoint support, 2.5.3
SELECT statement, 3.11.2, B.1.3, C.1.2
SMALL DATETIME data type, A.1
SMALLINT data type, A.1
Stored procedures, 2.5.5, 2.6.7
running in chained mode, 2.4.1
Stored procedures in SQL Server, 2.2
String functions, B.2.2.5, B.2.2.5
SUM function, 3.7

T

TIMESTAMP data type, A.1
TINYINT data type, A.1
Transaction modes, 2.4.1
transactional capability, 2.5.3
transactional integrity, 2.5.2
TRUNCATE statement, B.1
Two-phase commit, 2.5.3

U

UPDATE statement, 2.5.8.5, 3.9.2, 3.11.1, B.1.4, B.2.1

V

VARBINARY data type, 2.6.1, A.1
VARCHAR data type, A.1, A.1

W

WHERE CURRENT OF clause, 2.5.8.1