Table of Contents
- List of Tables
- Title and Copyright Information
- Preface
- 1 Introduction to the Oracle Database Gateway for Sybase
- 2
Sybase Gateway Features and Restrictions
- 2.1 Remote Insert Rowsource
- 2.2 Using the Pass-Through Feature
- 2.3 Executing Stored Procedures and Functions
- 2.4 CHAR Semantics
- 2.5 Multi-byte Character Sets Ratio Suppression
- 2.6 IPv6 Support
- 2.7 Gateway Session IDLE Timeout
- 2.8 Database Compatibility Issues for Sybase
- 2.9
Known Restrictions
- 2.9.1 Transactional Integrity
- 2.9.2 Transaction Capability
- 2.9.3 COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
- 2.9.4 Stored Procedures
- 2.9.5 Pass-Through Feature
- 2.9.6 Sybase NCHAR and NVARCHAR Data Types
- 2.9.7 SQL Syntax
- 2.9.8 SQL*Plus COPY Command with Lowercase Table Names
- 2.9.9 Database Links
- 2.10 Known Problems
- 3
Case Studies
- 3.1 Case Descriptions
- 3.2 Distribution Media Contents
- 3.3 Accessing the Demonstration Files
- 3.4 Demonstration Requirements
- 3.5 Creating Demonstration Tables
- 3.6 Case 1: Simple Queries
- 3.7 Case 2: A More Complex Query
- 3.8 Case 3: Joining Sybase Tables
- 3.9 Case 4: Write Capabilities
- 3.10 Case 5: Data Dictionary Query
- 3.11 Case 6: The Pass-Through Feature
- 3.12 Case 7: Executing Stored Procedures
- A Data Type Conversion
- B Supported SQL Syntax and Functions
- C
Data Dictionary
- C.1 Sybase System Tables
- C.2 Accessing the Gateway Data Dictionary
- C.3 Direct Queries to Sybase Tables
- C.4 Supported Views and Tables
- C.5 Data Dictionary Mapping
- C.6 Gateway Data Dictionary Descriptions
- C.7 ALL_CATALOG
- C.8 ALL_COL_COMMENTS
- C.9 ALL_CONS_COLUMNS
- C.10 ALL_CONSTRAINTS
- C.11 ALL_IND_COLUMNS
- C.12 ALL_INDEXES
- C.13 ALL_OBJECTS
- C.14 ALL_TAB_COLUMNS
- C.15 ALL_TAB_COMMENTS
- C.16 ALL_TABLES
- C.17 ALL_USERS
- C.18 ALL_VIEWS
- C.19 DBA_CATALOG
- C.20 DBA_COL_COMMENTS
- C.21 DBA_OBJECTS
- C.22 DBA_TAB_COLUMNS
- C.23 DBA_TAB_COMMENTS
- C.24 DBA_TABLES
- C.25 DICT_COLUMNS
- C.26 DICTIONARY
- C.27 DUAL
- C.28 TABLE_PRIVILEGES
- C.29 USER_CATALOG
- C.30 USER_COL_COMMENTS
- C.31 USER_CONS_COLUMNS
- C.32 USER_CONSTRAINTS
- C.33 USER_IND_COLUMNS
- C.34 USER_INDEXES
- C.35 USER_OBJECTS
- C.36 USER_TAB_COLUMNS
- C.37 USER_TAB_COMMENTS
- C.38 USER_TABLES
- C.39 USER_USERS
- C.40 USER_VIEWS
- D
Initialization Parameters
- D.1 Initialization Parameter File Syntax
- D.2
Oracle Database Gateway for Sybase Initialization Parameters
- D.2.1 HS_CALL_NAME
- D.2.2 HS_DB_DOMAIN
- D.2.3 HS_DB_INTERNAL_NAME
- D.2.4 HS_DB_NAME
- D.2.5 HS_DESCRIBE_CACHE_HWM
- D.2.6 HS_LANGUAGE
- D.2.7 HS_LONG_PIECE_TRANSFER_SIZE
- D.2.8 HS_OPEN_CURSORS
- D.2.9 HS_RPC_FETCH_REBLOCKING
- D.2.10 HS_RPC_FETCH_SIZE
- D.2.11 HS_TIME_ZONE
- D.2.12 HS_TRANSACTION_MODEL
- D.2.13 IFILE
- D.2.14 HS_FDS_VALIDATE_SERVER_CERT
- D.2.15 HS_FDS_ENCRYPT_SESSION
- D.2.16 HS_FDS_TRUSTSTORE_FILE
- D.2.17 HS_FDS_TRUSTSTORE_PASSWORD
- D.2.18 HS_FDS_TRANSACTION_ISOLATION
- D.2.19 HS_FDS_TIMESTAMP_MAPPING
- D.2.20 HS_FDS_DATE_MAPPING
- D.2.21 HS_FDS_CONNECT_INFO
- D.2.22 HS_FDS_PROC_IS_FUNC
- D.2.23 HS_FDS_RECOVERY_ACCOUNT
- D.2.24 HS_FDS_RECOVERY_PWD
- D.2.25 HS_FDS_RESULTSET_SUPPORT
- D.2.26 HS_FDS_TRACE_LEVEL
- D.2.27 HS_FDS_TRANSACTION_LOG
- D.2.28 HS_FDS_FETCH_ROWS
- D.2.29 HS_FDS_QUOTE_IDENTIFIER
- D.2.30 HS_IDLE_TIMEOUT
- D.2.31 HS_NLS_LENGTH_SEMANTICS
- D.2.32 HS_KEEP_REMOTE_COLUMN_SIZE
- D.2.33 HS_FDS_REMOTE_DB_CHARSET
- D.2.34 HS_FDS_SUPPORT_STATISTICS
- D.2.35 HS_FDS_RSET_RETURN_ROWCOUNT
- D.2.36 HS_FDS_SQLLEN_INTERPRETATION
- D.2.37 HS_FDS_REPORT_REAL_AS_DOUBLE
- D.2.38 HS_FDS_ARRAY_EXEC
- Index