Finding Compiled Object Errors Before Production

Changes made in versions of SAP ASE earlier than 12.5.x may cause compiled objects to work differently once you upgrade to a later version.

Use dbcc upgrade_object to find the errors and potential problem areas that may require manual changes to achieve the correct behavior.

After reviewing the errors and potential problem areas, and fixing those that need to be changed, use dbcc upgrade_object to upgrade compiled objects manually instead of waiting for the server to upgrade the objects automatically. See the Reference Manual: Commands.