Installation guide

10.9.6.1.1 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.

Context

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 the upgrade process automatically activates or deactivates quoted identifiers as

appropriate.

Procedure

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.

10.9.6.1.2 Determining Whether to Change select * in Views

Determine whether columns have been added to or deleted from the table since the view was created.

Context

Perform these queries when dbcc upgrade_object reports the existence of select * in a view:

Procedure

1. Compare the output of syscolumns for the original view to the output of the table.

Installation Guide for Linux

SAP ASE Upgrades

101