Oracle Transparent Gateway for Informix Administrator's Guide
Release 8.1.6
A80981-01
Library
Contents
Index
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
R
S
T
U
V
A
ALTER statement, A-2
Arithmetic operators, A-4
B
BYTE data type, 5-4
C
Case rules, 1-6
Case studies, 6-1
CD-ROM drive requirements, 1-3
CHAR data type, 5-4
COLUMN_VALUE_LONG function, 1-16
COMMIT
restrictions, 1-10
Commit point site, 1-10,
5-7
Comparison operators, A-4
Configuring
two-phase commit, 4-9
Configuring the gateway, 4-2
CONNECT BY clause, 1-12
Copying data
COPY command, 5-8
from Oracle database server to SQL Server, 5-8
from SQL Server to Oracle database server, 5-9
INSERT statement, 5-9
CREATE statement, A-2
CREATE TABLE command, 5-9
Creating
transaction log table, 4-10
Cursor loops
restrictions, 1-10
D
Data definition language, A-2
Data dictionary
contents, B-3
Oracle server name/SQL Server name, B-4
views, B-3
Data type
BYTE, 5-4
CHAR, 5-4
conversion, 1-8
DATETIME, 5-4
DECIMAL, 5-4
DOUBLE PRECISION, 5-4
FLOAT, 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
REAL, 5-4
SERIAL, 5-4
SMALLFLOAT, 5-4
SMALLINT, 5-4
TEXT, 5-4
VARCHAR, 5-4
VARCHAR2, 5-4
Database link
behavior, 4-11
Date functions, A-5
DATETIME data type, 5-4
DECIMAL data type, 5-4
DELETE statement, 6-9,
A-2,
A-3
restrictions on use, 1-13
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
DOUBLE PRECISION data type, 5-4
DROP statement, A-2
E
Encrypted format login, 1-15
Error message conventions, 7-6
Error messages
error tracing, C-4
ORA-12203, 7-4
ORA-12500, 7-5
Trace output, 7-9
Errors
ORA-02070, 1-10
F
FLOAT data type, 5-4
FOR UPDATE OF clause, 1-12
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,
B-2
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-5
H
Hardware requirements, 1-3
Hexadecimal notation, 1-7
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-4
HS_FDS_TRANSACTION_MODEL initialization parameter, C-5
HS_TRANSACTION_LOG, 4-10
HS_TRANSACTION_LOG table, 5-7
I
Informix
INFORMIX-SE, 1-4
Informix software requirements, 1-4
Initialization parameter file
customizing, 4-2
initsid.ora file, 4-2
INSERT statement, 6-11,
A-2,
A-3
restrictions on use, 1-13
Installing the gateway, 3-1 to
3-7
INTEGER data type, 5-4
INTERVAL data type, 1-11
K
Known restrictions, 1-9
L
listener.ora file, 4-14
example, 4-4
location, 4-3
Locking, database, 1-9
LONG data type, 5-4
LONG RAW data type, 5-4
M
Memory requirements, 1-3
MONEY data type, 5-4
N
NCHAR data type, 1-11,
5-4
Net8
configuration problems, 7-3
configuring, 4-3
requirements, 1-4
NLS
about, 1-14
NUMBER data type, 5-4
NUMERIC data type, 5-4
NVARCHAR data type, 1-11,
5-4
NVL function, 6-7
O
Objects
valid characters, 1-6
Objects, naming rules, 1-5
Operating system requirements, 1-3
ORA-02070, 1-10
ORA-12154, 7-3
ORA-12203, 7-4
ORA-12500, 7-5
Oracle database server
description, 2-4
error messages, 7-7
SQL construct processing, 5-3
Oracle functions
TO_DATE, A-6
Oracle Server
requirements, 1-3
P
Passing commands to database, 1-11
Pattern matching, A-5
PL/SQL, 1-16
Processor requirements, 1-3
Product set for Informix gateway, 1-2
R
RAW datatype, 1-7
REAL data type, 1-11,
5-4
RECOVERY_ACCOUNT
account username, 4-9
creating a recovery account, 4-9
Retrieving data from SQL Server, 5-2
ROLLBACK
restrictions, 1-10
S
savepoint support, 1-10
SELECT statement, 5-2,
A-2,
B-2
use of NULL keyword, 1-12
SERIAL data type, 5-4
Set operations, A-5
SID, 4-2
SMALLFLOAT data type, 1-11,
5-4
SMALLINT data type, 5-4
Software requirements, 1-3
Stored procedures, 1-14
String functions, A-5
SUM function, 6-7
Synonyms, 5-5
T
TEXT data type, 5-4
TNS listener
configuring for gateway, 4-3
starting, 4-5
starting for multiple gateway instances, 4-15
TO_DATE function, A-6
Trace output, 7-9
Transaction log table
creating, 4-10
transactional capability, 1-10
transactional integrity, 1-10
Troubleshooting
Net8 configuration problems, 7-3
TRUNCATE statement, A-2
Two-phase commit, 1-10,
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-12,
1-13
Updating SQL Server data, 5-3
V
VARCHAR data type, 5-4
VARCHAR2 data type, 5-4
Copyright © 2000 Oracle Corporation.
All Rights Reserved.
Library
Contents