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 the DELETE, UPDATE, and INSERT 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.