Altering all of the server definitions for a specific data source type

You can alter all of the existing server definitions for a particular type of data source in a single ALTER SERVER statement. Use a single statement when you want the same change to apply to all of the server definitions of the same type.

Before you begin

The authorization ID issuing the ALTER SERVER statement must include either SYSADM or DBADM authority on the federated database.

About this task

Restrictions

You can only set or drop server options using the ALTER SERVER statement for an entire type of data sources if the server options were added by a prior ALTER SERVER statement operation.

Procedure

To alter all of the existing server definitions for a particular type of data source, issue a single ALTER SERVER statement.

Example: Five Sybase servers are registered in the global catalog for your Sybase data sources. Whenever a user ID is sent to any of these Sybase servers for authentication, you want the federated server to always fold the user ID to uppercase. In addition, you want to set how long the federated server will wait for a response from these Sybase servers to an SQL statement. You specify the amount of time in seconds. You can modify all five server definitions at the same time the following ALTER SERVER statement:

ALTER SERVER TYPE sybase
   OPTIONS (ADD FOLD_ID 'U', ADD TIMEOUT '600')