PASS-THROUGH queries

Used when linking one database to another through an ODBC or JDBC connection. The query written in the local database is "passed through" 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)