Reference Manual
   CHAPTER 9. SQL Statements     

ALTER DATABASE statement

Function 

To upgrade a database created with previous versions of the software.

Syntax 

ALTER DATABASE UPGRADE
... [ JAVA { ON | OFF } ]
... [ JCONNECT { ON | OFF } ]

Permissions 

Must have DBA authority.

Not supported on Windows CE.

Side effects 

Automatic commit

See also 

CREATE DATABASE statement

The Upgrade utility

Description 

You can use the ALTER DATABASE statement as an alternative to the Upgrade utility to upgrade a database.

The JAVA clause adds the entries for the Sybase runtime Java classes to the system tables (JAVA ON) or does not (JAVA OFF). By default, the classes are added during the upgrade.

If you wish to use the Sybase jConnect JDBC driver to access system catalog information, you need to install jConnect support. If you wish to exclude the jConnect system objects, specify JCONNECT OFF. You can still use JDBC, as long as you do not access system information. The default is to include jConnect support.

     For information on adding Java support, see Java-enabling a Version 6 database. For information on adding jConnect support, see Installing the jConnect system objects.

Standards and compatibility 

• SQL/92     Vendor extension

• Sybase     Not supported by Adaptive Server Enterprise.

Example 

• Upgrade a Version 5 database to enable Java operations:

  ALTER DATABASE UPGRADE
  JAVA ON