1. User's Guide
  2. Case Studies
  3. Case 6: The Pass-Through Feature

3.10 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 6 demonstrates the gateway pass-through feature which allows an application to send commands or statements to SQL Server.

  • UPDATE Statement
    Demonstration using the pass-through feature and UPDATE statement.
  • SELECT Statement
    Demonstration using the pass-through feature and SELECT statement.

Parent topic: Case Studies

3.10.1 UPDATE Statement

Demonstration using the pass-through feature and UPDATE statement.

Case 6a provides an example of a pass-through UPDATE statement with bind variables. In this example, the salary for EMPNO 7934 is set to 4000.

Parent topic: Case 6: The Pass-Through Feature

3.10.2 SELECT Statement

Demonstration using the pass-through feature and SELECT statement.

Case 6b provides an example of a pass-through SELECT statement. The data that is returned from the SELECT statement is inserted into a local table at the Oracle database.

Parent topic: Case 6: The Pass-Through Feature