Index
A
B
C
D
E
F
G
H
I
K
L
M
N
O
P
R
S
T
U
V
W
Symbols
- ||, 1-17
A
- ALTER statement, A-2
- Arithmetic operators, A-4
B
- BINARY data type, 5-4
- BIT data type, 5-4
C
- 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, 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-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
D
- Data definition language, A-2
- Data dictionary
- contents, B-3
- Oracle server name/SQL Server name, B-4
- views, B-3
- Data type
- BINARY, 5-4
- BIT, 5-4
- CHAR, 5-4
- conversion, 1-7
- DATE, 5-4
- DATETIME, 5-4
- DECIMAL, 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
- NUMBER, 5-4
- NUMERIC, 5-4
- RAW, 5-4
- REAL, 5-4
- SMALL DATETIME, 5-4
- SMALL MONEY, 5-4
- SMALLINT, 5-4
- TEXT, 5-4
- TIMESTAMP, 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
- 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
- DROP statement, A-2
E
- 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-10
F
- FLOAT data type, 5-4
- Functions in SQL, 5-6
G
- 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-6
- installing, 3-1
- pass-through feature, 1-11, 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
H
- 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
I
- IMAGE data type, 5-4
- Initialization parameter file
- customizing, 4-2
- initsid.ora file, 4-2
- INSERT statement, 6-11, A-2, A-3
- Installing the gateway, 3-1 to 3-7
- INTEGER data type, 5-4
K
- Known restrictions, 1-9
L
- listener.ora file, 4-12
- 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
- Microsoft software requirements, 1-4
- MONEY data type, 5-4
N
- 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
- NVL function, 6-7
O
- 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
- requirements, 1-3
- SQL construct processing, 5-3
P
- Passing commands to database, 1-11
- Pattern Matching, A-4
- PL/SQL, 1-18
- Processor requirements, 1-3
- Product set for Informix gateway, 1-2
R
- 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-13
S
- savepoint support, 1-10
- SELECT statement, 5-2, A-2, B-2
- SID, 4-2
- SMALL DATETIME data type, 5-4
- SMALL MONEY data type, 5-4
- SMALLINT data type, 5-4
- Software requirements, 1-3
- Specifying an Owner, 4-10
- Stored procedures, 1-18
- running in chained mode, 1-5
- Stored procedures in SQL Server, 5-6
- String functions, A-5
- SUM function, 6-7
- Supported software
- Microsoft products, 1-4
- Synonyms, 5-5
T
- TEXT data type, 5-4
- TIMESTAMP 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-10
- transactional integrity, 1-10
- Troubleshooting
- Net8 configuration problems, 7-3
- TRUNCATE statement, A-2
- Two-phase commit, 2-8, 5-8
- configuration, 4-8
- transaction log table, 4-9
U
- UPDATE statement, 1-13, 5-3, 6-10, 6-13, 6-14, A-3
- Updating SQL Server data, 5-3
V
- VARBINARY data type, 1-15, 5-4
- VARCHAR data type, 5-4
- VARCHAR2 data type, 5-4
W
- WHERE CURRENT OF clause, 1-13