Home | Previous Page | Next Page   Managing Databases > Using Distributed Queries >

The Syntax of a Distributed Query

This section describes how to specify a remote server, database, and database object within a distributed query.

Note:
When designing distributed queries, be aware that some SQL syntax will not work across all server versions. Syntax that is valid on Dynamic Server but not on Extended Parallel Server is not supported on Extended Parallel Server and vice-versa.

Due to these potential syntax incompatibilities, an SQL statement may pass the checking stage on the coordinator, but return an error once that statement is passed to the participant.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]