Oracle Transparent Gateway for Ingres II Administrator's Guide
Release 8.1.6

Part Number A82871-01

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 


A

ALTER statement, A-2
Arithmetic operators, A-4

B

BYTE data type, 5-4
BYTE VARYING data type, 5-4

C

C data type, 5-4
Case rules, 1-5
Case studies, 6-1
CD-ROM drive requirements, 1-3
CHAR data type, 5-4
COLUMN_VALUE_LONG function, 1-10
COMMIT
restrictions, 1-9
Commit point site, 1-9, 5-7
Comparison operators, A-4
CONCAT operator, 1-15
Configuring
two-phase commit, 4-9
Configuring the gateway, 4-2
CONNECT BY clause, 1-11
Copying data
COPY command, 5-7
from Oracle database server to SQL Server, 5-7
from SQL Server to Oracle database server, 5-9
INSERT statement, 5-8
CREATE statement, A-2
CREATE TABLE command, 5-9
Creating
transaction log table, 4-10
Cursor loops
restrictions, 1-9

D

Data definition language, A-2
Data dictionary
contents, B-3
views, B-3
Data type
BYTE, 5-4
BYTE VARYING, 5-4
C, 5-4
CHAR, 5-4
conversion, 1-7
DATETIME, 5-4
DECIMAL, 5-4
FLOAT, 5-4
FLOAT4, 5-4
FLOAT8, 5-4
INTEGER, 5-4
INTEGER1, 5-4
INTEGER2, 5-4
INTEGER4, 5-4
LONG, 5-4
LONG BYTE, 5-4
LONG RAW, 5-4
LONG VARCHAR, 5-4
MONEY, 5-4
NUMBER, 5-4
OBJECT_KEY, 5-4
RAW, 5-4
SMALLINT, 5-4
TABLE_KEY, 5-4
TEXT, 5-4
VARCHAR, 5-4
VARCHAR2, 5-4
Database link
behavior, 4-11
Datatype
LONG BYTE, 1-10
LONG VARCHAR, 1-10
MONEY, 1-14
Date limits, 1-7
DATETIME data type, 5-4
DDL statement, 1-10
DECIMAL data type, 5-4
DELETE statement, 6-8, A-2
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-6
DROP statement, A-2

E

Encrypted format login, 1-13
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-9

F

FLOAT data type, 5-4
FLOAT4 data type, 5-4
FLOAT8 data type, 5-4
FOR UPDATE OF clause, 1-11

G

Gateway
case studies, 6-1
components, 2-3
data dictionary tables, B-2
default SID, 4-2
distributed query, 5-6
error messages, 7-7
how it works, 2-5
installing, 3-1
pass-through feature, 5-5
remote data access, 2-6
supported functions, A-1
supported SQL syntax, A-2
system identifier (SID), 4-2
two-phase commit, 2-8, 4-9, 5-7
GRANT statement, A-2
Group functions, A-4

H

Hardware requirements, 1-3
HS_COMMIT_POINT_STRENGTH setting, 5-7
HS_FDS_CONNECT_INFO initialization parameter, C-3
HS_FDS_RECOVERY_ACCOUNT initialization parameter, C-4
HS_FDS_RECOVERY_PWD initialization parameter, C-4
HS_FDS_TRACE_LEVEL initialization parameter, C-5
HS_FDS_TRANSACTION_MODEL initialization parameter, C-5
HS_TRANSACTION_LOG, 4-10
HS_TRANSACTION_LOG table, 5-7

I

Informix software requirements, 1-4
Initialization parameter file
customizing, 4-2
initsid.ora file, 4-2
INSERT statement, 6-10, A-2
Installing the gateway, 3-1 to 3-7
INTEGER data type, 5-4
INTEGER1 data type, 5-4
INTEGER2 data type, 5-4
INTEGER4 data type, 5-4

K

Known restrictions, 1-8

L

listener.ora file, 4-13
example, 4-4
location, 4-3
Locking, database, 1-8
LONG BYTE data type, 5-4
LONG BYTE datatype, 1-10
LONG data type, 5-4
LONG RAW data type, 5-4
LONG VARCHAR data type, 5-4
LONG VARCHAR datatype, 1-10

M

Memory requirements, 1-3
MONEY data type, 5-4
MONEY datatype, 1-14

N

Net8
configuration problems, 7-3
configuring, 4-3
requirements, 1-4
NLS
about, 1-12
NUMBER data type, 5-4
NVL function, 6-7

O

OBJECT_KEY data type, 5-4
Objects
valid characters, 1-5
Objects, naming rules, 1-5
Operating system requirements, 1-3
ORA-02070, 1-9
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

P

Passing commands to database, 1-10
Processor requirements, 1-3
Product set for Informix gateway, 1-2

R

RAW data type, 5-4
RECOVERY_ACCOUNT
account username, 4-9
creating a recovery account, 4-9
Retrieving data from SQL Server, 5-2
ROLLBACK
restrictions, 1-9
ROWID, 1-11

S

savepoint support, 1-9
SELECT statement, 5-2, A-2, B-2
SID, 4-2
SMALLINT data type, 5-4
Software requirements, 1-3
Stored procedures, 1-12
String functions, A-5
SUM function, 6-7
Synonyms, 5-5

T

TABLE_KEY data type, 5-4
TEXT data type, 5-4
TNS listener
configuring for gateway, 4-3
starting, 4-5
starting for multiple gateway instances, 4-14
Trace output, 7-9
Transaction log table
creating, 4-10
transactional capability, 1-9
transactional integrity, 1-9
Troubleshooting
Net8 configuration problems, 7-3
TRUNCATE statement, A-2
Two-phase commit, 1-9, 2-8, 5-7
configuration, 4-9
transaction log table, 4-10

U

UPDATE statement, 5-3, 6-10, 6-13, 6-14, A-3
restrictions on use, 1-11
Updating SQL Server data, 5-3

V

VARCHAR data type, 5-4
VARCHAR2 data type, 5-4

W

WHERE CURRENT OF clause, 1-11

Go to previous page.
Oracle logo.
Copyright © 2000 Oracle Corporation.

All Rights Reserved.

Contents