PASS-THROUGH queries

Used when linking one database to another through an ODBC (Open Database Connectivity) or JDBC (Java Database Connectivity  or Sun Java standard) connection. The query written in the local database is "passed through" as is to the database on the server and processed by the remote database.

Examples

- Update values in a remote table

- Find the next sequence number for a table (Oracle - uses the auxiliary table DUAL in the remote database)

- Run a query using a function or calculation that cannot be performed in the local database