SQL Statements and Logging Modes

You can run the following SQL statements across databases and across database servers.

To run each statement successfully across databases or database servers, the local and external databases must have the same logging mode.

Distributed cross-server operations on databases of remote database servers can only access values of the non-opaque built-in data types that are neither large objects nor complex data types. Distributed operations that use SQL statements or UDRs to access other databases of the local Dynamic Server instance, however, can also return the opaque built-in data types BLOB, BOOLEAN, CLOB, and LVARCHAR. They can also access DISTINCT types based on built-in types, as well as UDTs that can be cast to built-in types, provided that the DISTINCT or UDT values are explicitly cast to built-in types, and that all the DISTINCT types, UDTs, and casts are defined in all of the participating databases.

Note:

For INSERT, UPDATE, DELETE, LOAD, the target table cannot be on a remote server.

Note:

EXECUTE FUNCTION and EXECUTE PROCEDURE for remote functions and remote procedures are not supported on XPS.

SELECT	CREATE VIEW	UNLOAD
INSERT	CREATE SYNONYM	LOCK TABLE
UPDATE	DROP DATABASE	UNLOCK TABLE
DELETE	EXECUTE FUNCTION (IDS only)	INFO
DATABASE	EXECUTE PROCEDURE (IDS only)
CREATE DATABASE	LOAD