ALTER DATABASE Statement

Upgrades a database created with a previous version of the software or adds or removes jConnect™ for JDBC™ support. Run this statement with Interactive SQL.

Syntax

ALTER DATABASE UPGRADE
     [ PROCEDURE ON ]     
     [ JCONNECT { ON | OFF } ]

Examples

Example 1 – This example disables jConnect support:
```
ALTER DATABASE UPGRADE JCONNECT OFF
```

Usage

The ALTER DATABASE statement upgrades databases created with earlier versions of the software. This applies to maintenance releases as well as major releases.

When you upgrade a database, Sybase IQ makes these changes:

Upgrades the system tables to the current version.
Adds any new database options.
Enables new features in the current version.

You can also use ALTER DATABASE UPGRADE simply to add jConnect features, if the database was created with the current version of the software.

Note:

See the Installation and Configuration Guide for backup recommendations before you upgrade.
Be sure to start the server in a way that restricts user connections before you run ALTER DATABASE UPGRADE. For instructions and other upgrade caveats, see Installation and Configuration Guide > Database Upgrades for your platform.
Use the iqunload utility to upgrade databases created in versions earlier than 15.0. See Installation and Configuration Guide > Database Upgrades for your platform.

After using ALTER DATABASE UPGRADE, shut down the database.

PROCEDURE clause – drops and re-creates all dbo- and sys-owned procedures in the database.
JCONNECT clause – to allow the Sybase jConnect JDBC driver to access system catalog information, you must specify JCONNECT ON. This installs jConnect system tables and procedures. To exclude the jConnect system objects, specify JCONNECT OFF. You can still use JDBC, as long as you do not access system catalog information. The default is to include jConnect support (JCONNECT ON).

Side effects:

Automatic commit

Standards

SQL—Vendor extension to ISO/ANSI SQL grammar.
Sybase—Not supported by Adaptive Server Enterprise.

Permissions

Must have DBA authority.