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.

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. Server Config always discovers one reserved-word conflict for each database in your Adaptive Server. This is because the sysobjects table in Adaptive Server inserts a reserved word with each of its table entries. You do not need to address these conflicts, because they do not adversely affect the upgrade process.