3 Case Studies
The following case studies for Sybase demonstrate some of the features of the Oracle Database Gateway.
You can verify that the gateway is installed and operating correctly by using the demonstration files included on the distribution media.
The demonstration files are automatically copied to disk when the gateway is installed.
- Distribution Media Contents
This topic discusses the distribution media contents. - Accessing the Demonstration Files
After a successful gateway installation, use the demonstration files stored in the directory$ORACLE_HOME/dg4sybs/demo,
where$ORACLE_HOME
is the directory under which the gateway is installed. - Demonstration Requirements
This topic discusses the requirements for the case studies. - Creating Demonstration Tables
This topic discusses how to create demonstration tables for Oracle Database Gateway for Sybase. - Case 1: Simple Queries
Demonstration using simple queries. - Case 2: A More Complex Query
Demonstration using a more complex query. - Case 3: Joining Sybase Tables
Demonstration joining Sybase tables. - Case 4: Write Capabilities
Demonstration using write capabilities and theDELETE
,UPDATE
, andINSERT
statements. - Case 5: Data Dictionary Query
Demonstration using a data dictionary query. - Case 6: The Pass-Through Feature
Demonstration using the pass-through feature. - Case 7: Executing Stored Procedures
Demonstration executing stored procedures.