![]() | ![]() |
Home |
|
|
Installation Guide Adaptive Server Enterprise for Linux/Intel |
|
| Chapter 8 Upgrading Sybase Servers |
|
| Upgrading compiled objects with dbcc upgrade_object |
|
| Determining whether a compiled object has been upgraded |
To determine whether a compiled object has been upgraded, do one of the following:
Look at the sysprocedures.version column. If the object was upgraded, this column will contain the number 12500.
If you are upgrading to a 64-bit pointer size in the same version, look at the sysprocedures.status column. It will contain a hexadecimal bit setting of 0x2 to indicate that the object uses 64-bit pointers. If the bit is not set, the object is a 32-bit object, which means it was not upgraded.
|
|