3.10 Case 6: The Pass-Through Feature

Demonstration using the pass-through feature.

Case 6 demonstrates the gateway pass-through feature that allows an application to send commands or statements to Sybase.

This case demonstrates:

• A pass-through UPDATE statement using bind variables
• A pass-through SELECT statement

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

3.10.1 UPDATE Statement

Demonstration using the pass-through feature and the 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 the 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.