SAP Knowledge Base Article - Preview

1938432 - How to recompile statements via DBA Cockpit - SAP ASE for Business Suite


  • For various reasons you may need to compile all cached statements or stored procedures that use a particular database table.
  • Usually this is done using the ISQL command line utility to run:

sp_recompile <table name>

  • However, you experience an issue when running ISQL so you want to do this via DBACOCKPIT instead.



SAP Adaptive Server Enterprise (ASE) 15.7 for Business Suite


SAP Adaptive Server Enterprise 15.7 ; SAP ERP 6.0 ; SAP NetWeaver 7.4 ; SAP NetWeaver all versions


KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.