Installation guide

Note: Before upgrading, use sp_renamedb to change the name of any user database that is a
reserved word.
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 for a complete list of
reserved words.
Running a Reserved Word Check
Run the reserved word check on the old Adaptive Server.
Even if you plan to use sqlupgraderes to upgrade Adaptive Server 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 preforming 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.
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/sqlupgradeMMDD.nnn. Review this file to determine which identifiers
to change.
2.
The Server Config utility installs sp_checkreswords and checks the reserved words
during the upgrade. Server Config does not display the names or locations of identifiers
that conflict with reserved words; only the number of conflicts.
Addressing Reserved Words Conflicts
Change any database names that are reserved words.
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:
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 77