Skip Headers
Oracle® Database Gateway for Sybase User's Guide
11g Release 1 (11.1)
Part Number B31048-03
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
Contents
List of Tables
Title and Copyright Information
Preface
Audience
Documentation Accessibility
Related Documents
Conventions
1
Introduction
1.1
Overview
1.2
Heterogeneous Services Technology
1.3
Oracle Database Gateways
2
Sybase Gateway Features and Restrictions
2.1
Using the Pass-Through Feature
2.2
Executing Stored Procedures and Functions
2.2.1
Return Values and Stored Procedures
2.2.2
Result Sets and Stored Procedures
2.2.2.1
OCI Program Fetching from Result Sets in Sequential Mode
2.2.2.2
PL/SQL Program Fetching from Result Sets in Sequential Mode
2.3
Database Compatibility Issues for Sybase
2.3.1
Chained Mode
2.3.2
Column Definitions
2.3.3
Naming Rules
2.3.3.1
Rules for Naming Objects
2.3.3.2
Case Sensitivity
2.3.4
Data Types
2.3.4.1
Binary Literal Notation
2.3.4.2
Data Type Conversion
2.3.5
Queries
2.3.5.1
Row Selection
2.3.5.2
Empty Strings
2.3.5.3
Empty Bind Variables
2.3.6
Locking
2.4
Known Restrictions
2.4.1
Transactional Integrity
2.4.2
Transaction Capability
2.4.3
COMMIT or ROLLBACK in PL/SQL Cursor Loops Closes Open Cursors
2.4.4
Stored Procedures
2.4.5
Pass-Through Feature
2.4.6
Sybase NCHAR and NVARCHAR Data Types
2.4.7
SQL Syntax
2.4.7.1
WHERE CURRENT OF Clause
2.4.7.2
CONNECT BY Clause
2.4.7.3
ROWID
2.4.7.4
Subqueries in INSERT Statement
2.4.7.5
EXPLAIN PLAN Statement
2.4.7.6
Callback Support
2.4.8
SQL*Plus COPY Command with Lowercase Table Names
2.4.9
Database Links
2.5
Known Problems
2.5.1
Encrypted Format Login
2.5.2
Date Arithmetic
2.5.3
Sybase IMAGE and TEXT Data Type
2.5.4
String Functions
2.5.5
Schema Names and PL/SQL
2.5.6
Data Dictionary Views and PL/SQL
2.5.7
Stored Procedures
3
Case Studies
3.1
Case Descriptions
3.2
Distribution Media Contents
3.3
Demonstration Files
3.4
Demonstration Requirements
3.5
Creating Demonstration Tables
3.5.1
Demonstration Table Definitions
3.5.2
Demonstration Table Contents
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.9.1
DELETE Statement
3.9.2
UPDATE Statement
3.9.3
INSERT Statement
3.10
Case 5: Data Dictionary Query
3.11
Case 6: The Pass-Through Feature
3.11.1
UPDATE Statement
3.11.2
SELECT Statement
3.12
Case 7: Executing Stored Procedures
A
Data Type Conversion
A.1
Data Type Conversion
B
Supported SQL Syntax and Functions
B.1
Supported SQL Statements
B.1.1
DELETE
B.1.2
INSERT
B.1.3
SELECT
B.1.4
UPDATE
B.2
Oracle Functions
B.2.1
Functions Not Supported by Sybase
B.2.2
Functions Supported by Sybase
B.2.2.1
Arithmetic Operators
B.2.2.2
Comparison Operators
B.2.2.3
Group Functions
B.2.2.4
String Functions
B.2.2.5
Other Functions
C
Data Dictionary
C.1
Data Dictionary Support
C.1.1
Sybase System Tables
C.1.2
Accessing the Gateway Data Dictionary
C.1.3
Direct Queries to Sybase Tables
C.1.4
Supported Views and Tables
C.2
Data Dictionary Mapping
C.2.1
Default Column Values
C.3
Gateway Data Dictionary Descriptions
D
Initialization Parameters
D.1
Initialization Parameter File Syntax
D.2
Oracle Database Gateway for Sybase Initialization Parameters
D.3
Initialization Parameter Description
D.3.1
HS_CALL_NAME
D.3.2
HS_DB_DOMAIN
D.3.3
HS_DB_INTERNAL_NAME
D.3.4
HS_DB_NAME
D.3.5
HS_DESCRIBE_CACHE_HWM
D.3.6
HS_LANGUAGE
D.3.6.1
Character Sets
D.3.6.2
Language
D.3.6.3
Territory
D.3.7
HS_LONG_PIECE_TRANSFER_SIZE
D.3.8
HS_OPEN_CURSORS
D.3.9
HS_RPC_FETCH_REBLOCKING
D.3.10
HS_RPC_FETCH_SIZE
D.3.11
HS_TIME_ZONE
D.3.12
HS_TRANSACTION_MODEL
D.3.13
IFILE
D.3.14
HS_FDS_CONNECT_INFO
D.3.15
HS_FDS_DEFAULT_OWNER
D.3.16
HS_FDS_PROC_IS_FUNC
D.3.17
HS_FDS_RECOVERY_ACCOUNT
D.3.18
HS_FDS_RECOVERY_PWD
D.3.19
HS_FDS_RESULTSET_SUPPORT
D.3.20
HS_FDS_TRACE_LEVEL
D.3.21
HS_FDS_TRANSACTION_LOG
D.3.22
HS_FDS_FETCH_ROWS
Index