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.

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.

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.