Upgrade System Tables and Stored Procedures

When you upgrade Adaptive Server, drop and re-create syscomments to include the new and changed tables.

When you upgrade the Cluster Edition, system tables are also updated, which may affect your existing application. See System Changes in the Clusters Users Guide for a complete list of catalogs that are affected.

If you deleted text from the syscomments system table, drop and re-create the stored procedures to again add the text. SAP recommends that you use the sp_hidetext stored procedure to hide text, rather than deleting text.

If you modified any system stored procedures without altering their names, back them up before you upgrade Adaptive Server. The upgrade process overwrites these modified procedures with default versions.