Changed System Procedures

SAP ASE 16.0 includes changes to existing system procedures.

• sp_audit
  SAP ASE 16.0 adds the config_history auditing option.
• sp_chgattribute
  The pnt_locking table attribute enables and disables partition level locking with sp_chgattrbute. By default, partition locking is disabled.
• sp_clusterlockusage
  sp_clusterlockusage output has been enhanced to print cluster lock usage information that is specific to partition locks.
• sp_dboption
  The sp_dboption system procedure supports the ability to remove residual data from deletions in SAP ASE.
• sp_depends
  In SAP ASE version 16.0, you can use sp_depends to list the multiple triggers associated with a table.
• sp_encryption
  The sp_encryption system procedure reports a new key type called "database encryption key" to show if a database is fully encrypted.
• sp_familylock
  A partitionid column has been added to the output of the sp_familylock stored procedure.
• sp_helpdb
  The sp_helpdb system procedure supports the full database encryption feature.
• sp_lock
  The partitionid column has been added to the output of the sp_lock stored procedure.