Installation guide

Problem Description Solution
Reserved word er-
rors
If you load a database dump from an earlier
version of Adaptive Server into Adaptive Serv-
er 15.7 or later and the dump contains a stored
procedure that uses a word that is now reserved,
when you run dbcc upgrade_object on that
stored procedure, the command returns an error.
Either manually change the
object name or use quotes
around the object name, and
issue the command set quo-
ted identifiers on. Then drop
and re-create the compiled
object.
Quoted Identifier Errors
Quoted identifiers are not the same as literals enclosed in double quotes. The latter do not
require you to perform any special action before the upgrade.
dbcc upgrade_object returns a quoted identifier error if:
• The compiled object was created in a pre-11.9.2 version with quoted identifiers active (set
quoted identifiers on).
• Quoted identifiers are not active (set quoted identifiers off) in the current session.
For compiled objects created in version 11.9.2 or later, the upgrade process automatically
activates or deactivates quoted identifiers as appropriate.
1.
Activate quoted identifiers before running dbcc upgrade_object.
When quoted identifiers are active, use single quotes instead of double quotes around
quoted dbcc upgrade_object keywords.
2.
If quoted identifier errors occur, use the set command to activate quoted identifiers, and
then run dbcc upgrade_object to upgrade the object.
Determining Whether to Change select * in Views
Determine whether columns have been added to or deleted from the table since the view was
created.
Perform these queries when dbcc upgrade_object reports the existence of select * in a view:
1.
Compare the output of syscolumns for the original view to the output of the table.
In this example, you have the following statement:
create view all_emps as select * from employees
Warning! Do not execute a select * statement from the view. Doing so upgrades the view
and overwrites the information about the original column information in syscolumns.
2.
Before upgrading the all_emps view, use these queries to determine the number of
columns in the original view and the number of columns in the updated table:
select name from syscolumns
where id = object_id("all_emps")
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 103