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.

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.
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.