Running a Reserved Word Check

If you plan to use sqlupgraderes to perform the upgrade process using a resource file, you can run sqlupgrade first to identify reserved word conflicts and other potential upgrade eligibility problems. You can specify that you do not want the upgrade to proceed even if no problems are found.

In sqlupgrade, you can check for reserved words at the start of the upgrade process, and then continue with the upgrade if no problems are found.

Both sqlupgrade or sqlupgraderes, automatically install new reserved words and sp_checkreswords. sp_checkreswords is a stored procedure used to detect and display identifiers in your existing databases that conflict with reserved words in the new database. You can then run the new version of sp_checkreswords at any time while preforming pre-upgrade tasks.

Note:

You must use the sp_checkreswords stored procedure from the new version of Adaptive Server to verify that the old installation of Adaptive Server does not use any reserved words that have been introduced with the new server.

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 must be changed.
The sp_checkreswords system procedure detects and displays any identifiers in your existing databases that conflict with reserved words. Server Config installs sp_checkreswords and checks the reserved words during the upgrade. Server Configdoes not display the names or locations of identifiers that conflict with reserved words, only the number of conflicts.