Installation guide

If you change an object name, also change applications and stored procedures that refer to that object. Conflicts

between object names do not prevent the upgrade process from completing. However, applications that refer to

conflicting object names may not work after the upgrade. Rename all objects that use reserved words.

As part of the preupgrade process, you can have sqlupgrade, sqlupgraderes, or preupgrade perform a

reserved-word check for you. See the Reference Manual: Building Blocks for a complete list of reserved words.

10.5.2.1 Running a Reserved Word Check

Run the reserved word check on the SAP ASE server you are upgrading.

Context

Even if you plan to use sqlupgraderes to upgrade SAP ASE noninteractively, you can still first run the interactive

sqlupgrade utility to perform reserved-word checks and other potential upgrade eligibility problems, and then

continue with the upgrade if no problems are found.

Both sqlupgrade and sqlupgraderes automatically install new reserved words and the sp_checkreswords

system procedure, which detects and displays identifiers in your existing databases that conflict with reserved

words in the new database. You can use sp_checkreswords at any time while performing preupgrade tasks.

Note

Do not use an older version of sp_checkreswords to check for reserved words, as it does not contain the

most current list of reserved words.

Procedure

1. Checking for reserved words generates a list of identifiers that conflict with reserved words, and the owners of

those identifiers, in the file $SYBASE/$SYBASE_ASE/init/logs/sqlupgrade<MMDD.nnn>. Review this file

to determine which identifiers to change.

2. The sqlupgrade utility installs sp_checkreswords and checks the reserved words during the upgrade.

Installation Guide for Linux

SAP ASE Upgrades