Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- 1 Introduction to the Oracle Database Gateway for SQL Server
-
2
SQL Server Gateway Features and Restriction
- Remote Insert Rowsource
- Using the Pass-Through Feature
- Executing Stored Procedures and Functions
- CHAR Semantics
- Multi-byte Character Sets Ratio Suppression
- IPv6 Support
- Gateway Session IDLE Timeout
- Remote User-defined Function Support
- Database Compatibility Issues for SQL Server
- Known Restrictions
- Known Problems
-
3
Case Studies
- Case Descriptions
- Installation Media Contents
- Demonstration Files
- Demonstration Requirements
- Creating Demonstration Tables
- Case 1: Simple Queries
- Case 2: A More Complex Query
- Case 3: Joining SQL Server Tables
- Case 4: Write Capabilities
- Case 5: Data Dictionary Query
- Case 6: The Pass-Through Feature
- Case 7: Executing Stored Procedures
- A Data Type Conversion
- B Supported SQL Syntax and Functions
-
C
Data Dictionary
- Data Dictionary Support
- Data Dictionary Mapping
- Gateway Data Dictionary Descriptions
- ALL_CATALOG
- ALL_COL_COMMENTS
- ALL_CONS_COLUMNS
- ALL_CONSTRAINTS
- ALL_IND_COLUMNS
- ALL_INDEXES
- ALL_OBJECTS
- ALL_TAB_COLUMNS
- ALL_TAB_COMMENTS
- ALL_TABLES
- ALL_USERS
- ALL_VIEWS
- DBA_CATALOG
- DBA_COL_COMMENTS
- DBA_OBJECTS
- DBA_TAB_COLUMNS
- DBA_TAB_COMMENTS
- DBA_TABLES
- DICT_COLUMNS
- DICTIONARY
- DUAL
- TABLE_PRIVILEGES
- USER_CATALOG
- USER_COL_COMMENTS
- USER_CONS_COLUMNS
- USER_CONSTRAINTS
- USER_IND_COLUMNS
- USER_INDEXES
- USER_OBJECTS
- USER_TAB_COLUMNS
- USER_TAB_COMMENTS
- USER_TABLES
- USER_USERS
- USER_VIEWS
-
D
Initialization Parameters
- Initialization Parameter File Syntax
- Oracle Database Gateway for SQL Server Initialization Parameters
- HS_CALL_NAME
- HS_DB_DOMAIN
- HS_DB_INTERNAL_NAME
- HS_DB_NAME
- HS_DESCRIBE_CACHE_HWM
- HS_LANGUAGE
- HS_LONG_PIECE_TRANSFER_SIZE
- HS_OPEN_CURSORS
- HS_RPC_FETCH_REBLOCKING
- HS_RPC_FETCH_SIZE
- HS_TIME_ZONE
- HS_FDS_ENCRYPT_SESSION
- HS_FDS_TRANSACTION_ISOLATION
- HS_FDS_TRUSTSTORE_FILE
- HS_FDS_TRUSTSTORE_PASSWORD
- HS_FDS_VALIDATE_SERVER_CERT
- HS_TRANSACTION_MODEL
- IFILE
- HS_FDS_TIMESTAMP_MAPPING
- HS_FDS_DATE_MAPPING
- HS_FDS_CONNECT_INFO
- HS_FDS_PROC_IS_FUNC
- HS_FDS_RECOVERY_ACCOUNT
- HS_FDS_RECOVERY_PWD
- HS_FDS_REPORT_REAL_AS_DOUBLE
- HS_FDS_RESULTSET_SUPPORT
- HS_FDS_TRACE_LEVEL
- HS_FDS_TRANSACTION_LOG
- HS_FDS_FETCH_ROWS
- HS_IDLE_TIMEOUT
- HS_NLS_LENGTH_SEMANTICS
- HS_KEEP_REMOTE_COLUMN_SIZE
- HS_FDS_REMOTE_DB_CHARSET
- HS_FDS_SUPPORT_STATISTICS
- HS_FDS_RSET_RETURN_ROWCOUNT
- HS_FDS_SQLLEN_INTERPRETATION
- HS_FDS_ARRAY_EXEC
- Index