3 Case Studies

The following case studies for SQL Server 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 in the distribution media.

The demonstration files are automatically copied to disk when the gateway is installed.

• Installation Media Contents
  This topic describes the installation media contents.
• Demonstration Files
  After a successful gateway installation, use the demonstration files stored in the directory ORACLE_HOME\dg4msql\demo where ORACLE_HOME is the directory under which the gateway is installed.
• Demonstration Requirements
  Case study requirements.
• Creating Demonstration Tables
  The case studies are based on the GTW_EMP, GTW_DEPT, and GTW_SALGRADE tables and the stored procedures InsertDept and GetDept. If the demonstration tables and stored procedures have not been created in the SQL Server database, use the bldmsql.sql script to create them.
• Case 1: Simple Queries
  Demonstration using simple queries.
• Case 2: A More Complex Query
  Demonstration using more complex queries.
• Case 3: Joining SQL Server Tables
  Demonstration joining SQL Server tables.
• Case 4: Write Capabilities
  Demonstration using write capabilities and the DELETE, UPDATE, and INSERT statemetns.
• Case 5: Data Dictionary Query
  Demonstration using data dictionary queries.
• Case 6: The Pass-Through Feature
  Demonstration of the pass-through feature using the UPDATE statement with bind variables and using the SELECT statement.
• Case 7: Executing Stored Procedures
  Demonstration executing stored procedures.