Oracle Transparent Gateway Sybase Administrator's Guide -- Index

||, 1-17

ALTER statement, A-2

Arithmetic operators, A-4

BINARY data type, 5-4

BIT data type, 5-4

Case rules, 1-6

Case studies, 6-1

CD-ROM drive requirements, 1-3

Chained mode, 1-5

CHAR data type, 5-4

COMMIT

restrictions, 1-11

Commit point site, 1-11, 5-8

Comparison operators, A-4

CONCAT operator, 1-17

Configuring

two-phase commit, 4-8

Configuring the gateway, 4-2

CONNECT BY clause, 1-12

COPY command, 1-13

Copying data

COPY command, 5-9

from Oracle database server to SQL Server, 5-9

from SQL Server to Oracle database server, 5-10

INSERT statement, 5-10

CREATE statement, A-2

CREATE TABLE command, 5-10

Creating

transaction log table, 4-9

Cursor loops

restrictions, 1-11

Data definition language, A-2

Data dictionary

views, B-3

Data type

BINARY, 5-4

BIT, 5-4

CHAR, 5-4

conversion, 1-8

DATE, 5-4

DATETIME, 5-4

DECIMAL, 5-4

DOUBLE PRECISION, 5-4

FLOAT, 5-4

FLOAT data type, 1-15

IMAGE, 5-4

INTEGER, 5-4

LONG, 5-4

LONG RAW, 5-4

MONEY, 5-4

NCHAR, 5-4

NUMBER, 5-4

NUMERIC, 5-4

NVARCHAR, 5-4

RAW, 5-4

REAL, 5-4

SMALL DATETIME, 5-4

SMALL MONEY, 5-4

SMALLINT, 5-4

TEXT, 5-4

TINYINT, 5-4

VARBINARY, 1-15, 5-4

VARCHAR, 5-4

VARCHAR2, 5-4

Database link

behavior, 4-10

DATE data type, 5-4

DATETIME data type, 5-4

DDL statement, 1-11

DECIMAL data type, 5-4

DELETE statement, 6-9, A-2, A-3

Demo build SQL script, 6-2

Demonstration files, 6-2

Demonstration tables, 6-3

Demonstration tables build SQL script, 6-3

Disk space requirements, 1-3

Distributed queries, 5-7

DOUBLE PRECISION data type, 5-4

DROP statement, A-2

Encrypted format login, 1-15

Error message conventions, 7-6

Error messages

error tracing, C-5

ORA-12203, 7-4

ORA-12500, 7-5

Trace output, 7-9

Errors

ORA-02070, 1-11

FLOAT data type, 5-4

Functions in SQL, 5-6

Gateway

case studies, 6-1

components, 2-3

data dictionary tables, B-2

default SID, 4-2

distributed query, 5-7

error messages, 7-7

how it works, 2-5

installing, 3-1

pass-through feature, 5-5

remote data access, 2-7

supported functions, A-1

supported SQL syntax, A-2

system identifier (SID), 4-2

two-phase commit, 2-8, 4-8, 5-8

GRANT statement, A-2

Group functions, A-5

Hardware requirements, 1-3

Hexadecimal notation, 1-7

HS_COMMIT_POINT_STRENGTH setting, 5-8

HS_FDS_CONNECT_INFO initialization parameter, C-3

HS_FDS_DEFAULT_OWNER initialization parameter, 4-10, C-4

HS_FDS_PROC_IS_FUNC initialization parameter, C-4

HS_FDS_RECOVERY_ACCOUNT initialization parameter, C-4

HS_FDS_RECOVERY_PWD initialization parameter, C-5

HS_FDS_TRACE_LEVEL initialization parameter, C-5

HS_FDS_TRANSACTION_MODEL initialization parameter, C-6

HS_TRANSACTION_LOG, 4-9

HS_TRANSACTION_LOG table, 5-8

IMAGE data type, 5-4

Informix software requirements, 1-4

Initialization parameter file

customizing, 4-2

initsid.ora file, 4-2

INSERT statement, 1-13, 6-11, A-2, A-3

Installing the gateway, 3-1 to 3-7

INTEGER data type, 5-4

Known restrictions, 1-9

listener.ora file, 4-13

example, 4-4

location, 4-3

Locking, database, 1-9

LONG data type, 5-4

LONG RAW data type, 5-4

Memory requirements, 1-3

MONEY data type, 5-4

NCHAR data type, 5-4

Net8

configuration problems, 7-3

configuring, 4-3

requirements, 1-4

NLS

about, 1-14

NULL values, 1-5

NUMBER data type, 5-4

NUMERIC data type, 5-4

NVARCHAR data type, 5-4

NVL function, 6-7

Objects, naming rules, 1-6

Operating system requirements, 1-3

ORA-02070, 1-11

ORA-12154, 7-3

ORA-12203, 7-4

ORA-12500, 7-5

Oracle database server

description, 2-4

error messages, 7-7

requirements, 1-3

SQL construct processing, 5-3

Passing commands to database, 1-11

Pass-through feature, 1-11

PL/SQL, 1-17

Processor requirements, 1-3

Product set for Informix gateway, 1-2

RAW data type, 5-4

REAL data type, 5-4

RECOVERY_ACCOUNT

account username, 4-8

creating a recovery account, 4-8

Retrieving data from SQL Server, 5-2

ROLLBACK

restrictions, 1-11

ROWID, 1-12, 1-13

savepoint support, 1-11

SELECT statement, 5-2, A-2, B-2

SID, 4-2

SMALL DATETIME data type, 5-4

SMALLINT data type, 5-4

Software requirements, 1-3

Specifying an Owner, 4-10

Stored procedures, 1-17

running in chained mode, 1-5

Stored procedures in SQL Server, 5-6

String functions, A-4

SUM function, 6-7

Synonyms, 5-5

TEXT data type, 5-4

TINYINT data type, 5-4

TNS listener

configuring for gateway, 4-3

starting, 4-5

Trace output, 7-9

Transaction log table

creating, 4-9

Transaction modes, 1-5

transactional capability, 1-11

transactional integrity, 1-10

Troubleshooting

Net8 configuration problems, 7-3

TRUNCATE statement, A-2

Two-phase commit, 1-11, 2-8, 5-8

configuration, 4-8

transaction log table, 4-9

UPDATE statement, 1-12, 5-3, 6-10, 6-13, 6-14, A-3

Updating SQL Server data, 5-3

VARBINARY data type, 1-15, 5-4

VARCHAR data type, 5-4

VARCHAR2 data type, 5-4

WHERE CURRENT OF clause, 1-12

Index

Symbols

A

B

C

D

E

F

G

H

I

K

L

M

N

O

P

R

S

T

U

V

W