Reserved words can be used only by Adaptive Server, not by applications connecting to Adaptive Server. Most new versions of Adaptive Server contain new reserved words as a result of new object and commands.
Before you upgrade Adaptive Server, you must change all object names that contain reserved words. You must also change those names in your procedures, Transact- SQL scripts, and applications before you can run them against the upgraded server. To check the object names, use the reserved word check in sqlupgrade, which you can run without starting the upgrade. Alternatively, you can apply the installupgrade script from the $SYBASE/ASE-15_0/scripts directory against your older Adaptive Server and run the sp_checkreswords stored procedure on this Adaptive Server.
You cannot use the Sybase procedures for detecting reserved
words in objects to find them in scripts and applications. Check
scripts and applications separately.
You can use sp_rename to change names that contain reserved words can be changed with sp_rename, or you can enclosed them in double quotes. See the discussion on reserved words in the installation guide for your platform.
See the Reference Manual: Blocks for a complete list of reserved words. See What’s New in Adaptive Server Enterprise for a list of reserved words added for each release.
