Installation guide

10.5.2.2 Addressing Reserved Words Conflicts

Change any database names that are reserved words.

Procedure

1. Use sp_dboption to set the database to single-user mode, then run sp_renamedb, specifying the new

name.

2. If other identifiers are reserved words, you can use:

○ sp_rename to change the name of the object, before or after the upgrade.

○ Quoted identifiers.

○ Brackets around the identifier. For example:

create table [table] ( [int] int, [another int] int )

3. Run sp_checkreswords in master and in each user database to display the names and locations of

conflicting identifiers.

See Reference Manual: Procedures for information about sp_dboption, sp_rename, and

sp_checkreswords.

10.5.2.3 Quoted Identifiers

To avoid reserved word conflicts, all users on the server must invoke the quoted_identifier option in all stored

procedures and queries that include the reserved words.

To invoke the quoted_identifier option of the set command in procedures and queries that include the

reserved words, enclose the reserved words that are identifiers in double quotation marks. The set

quoted_identifier option tells SAP ASE to treat any character string enclosed in double quotation marks as

an identifier.

See Reference Manual: Commands for more information on set quoted_identifier.

10.5.3 Preparing the Database and Devices

Before starting the upgrade process, confirm that you have enough space for the upgrade to succeed.

Procedure

1. To calculate the free space required for the upgrade to succeed, double the size of the largest catalog that

you are going to upgrade, then add approximately 10 percent. For example, if you have a large number of

Installation Guide for Linux

SAP ASE Upgrades