When you upgrade Adaptive Server, drop and re-create syscomments to include the new and changed tables.
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.