ALTER SERVER CONNECTION CLOSE syntax [CR 447958, CR 429434]

The syntax for the ALTER SERVER CONNECTION CLOSE clause was omitted from the Sybase IQ Reference Manual. The following information should be added to the “ALTER SERVER statement” section in Chapter 6, “SQL Statements.”

Add the following clause to the ALTER SERVER syntax: [ CONNECTION CLOSE [ CURRENT | ALL | connection-id ] ]
Add the following examples to the “Examples” section:

The following example closes all connections to the remote server named rem_test.
```
ALTER SERVER rem_test
CONNECTION CLOSE ALL
```
The following example closes the connection to the remote server named rem_test that has the connection ID 142536.
```
ALTER SERVER rem_test
CONNECTION CLOSE 142536
```
Add the following information to the “Usage” section:

CONNECTION CLOSE clause When a user creates a connection to a remote server, the remote connection is not closed until the user disconnects from the local database. The CONNECTION CLOSE clause allows you to explicitly close connections to a remote server. You may find this useful when a remote connection becomes inactive or is no longer needed.

The following SQL statements are equivalent and close the current connection to the remote server:
```
ALTER SERVER server-name CONNECTION CLOSE
```
```
ALTER SERVER server-name CONNECTION CLOSE CURRENT
```
You can close both ODBC and JDBC connections to a remote server using this syntax. You do not need DBA authority to execute either of these statements.

You can also disconnect a specific remote ODBC connection by specifying a connection ID, or disconnect all remote ODBC connections by specifying the ALL keyword. If you attempt to close a JDBC connection by specifying the connection ID or the ALL keyword, an error occurs. When the connection identified by connection-id is not the current local connection, the user must have DBA authority to be able to close the connection.