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 theUPDATE
statement. - SELECT Statement
Demonstration using the pass-through feature and theSELECT
statement.
Parent topic: Case Studies
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
.
Parent topic: Case 6: The Pass-Through Feature
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.
Parent topic: Case 6: The Pass-Through Feature