Sybase Adaptive Server 15.0.2, Installation Manual

Page: 78 / 160

Pre-upgrade tasks
64
Adaptive Server Enterprise
Noting server and device names and locations
By default, the
master
(master.dat) and system procedures device
(sybsytemprocs.dat) files are installed in the %SYBASE%\data directory. The
device file names can be different from their device names.
Be sure that the directory to which your TEMP environment variable points
exists. The installation program uses the directory to write files temporarily
during the installation, which it locates via the TEMP environment variable.
Procedure text is required for upgrade
If you created any compiled objects or stored procedures in a pre-11.9.3 server,
then removed the
syscomments
text, the upgrade succeeds but you will
encounter runtime problems. To upgrade stored procedures, the stored
procedure text must be available in
syscomments
.
To successfully upgrade to Adaptive Server version 15.0.2:
• Reinstall the procedures with text, or
• Remove them and reinstall them after the upgrade.
You can also hide the text using the
sp_hidetext
stored procedure.
Reserved words
Reserved words are pieces of SQL syntax that have special meaning when used
as part of a command.
Transact-SQL does not allow words that are part of command syntax to be used
as identifiers, unless they are enclosed in quotation marks. If you are upgrading
Adaptive Server, and the identifiers in your user databases match new reserved
words, errors result when you run queries, stored procedures, or applications
that use these identifiers.
Note
Before performing your upgrade, change the name of any user database
that is a reserved word using the
sp_renamedb
stored procedure.
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.