Home | Previous Page | Next Page   Managing Databases >

Using Distributed Queries

In This Chapter
Overview of Distributed Queries
Coordinator and Participant in a Distributed Query
Configuring the Database Server to Use Distributed Queries
The Syntax of a Distributed Query
Accessing a Remote Server and Database
Database Name
Database Object Name
Specifying a Coserver ID (XPS)
Valid Statements for Accessing Remote Objects
Accessing Remote Tables
Table Permissions
Qualifying Table References
Other Remote Operations
Opening a Remote Database
Creating a Remote Database
Creating a Remote Synonym
Monitoring Distributed Queries
Server Environment and Distributed Queries
PDQPRIORITY Environment Variable
DEADLOCK_TIMEOUT
Database Access Restrictions
Transaction Processing
Isolation Levels
DEADLOCK_TIMEOUT and SET LOCK MODE
Two-phase Commit and Recovery
Cross Server Compatibility Issues (XPS)
BYTE and TEXT Data Types
Other Restrictions
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]