Changed System Procedures

Changed Adaptive Server 15.7 SP100 system procedures.

• sp_configure
  The sp_configure system procedure supports features introduced in Adaptive Server 15.7 SP100.
• sp_config_rep_agent
  The sp_config_rep_agent system procedure has been updated to support the additional distribution model filter for the multipath distribution model property.
• sp_dboption
  Adaptive Server 15.7 SP100 introduces new parameters for the sp_dboption system procedure.
• sp_depends
  Adaptive Server 15.7 SP100 introduces a new option in the sp_depends system procedure to display information about precomputed result sets.
• sp_dump_history
  In Adaptive Server 15.7 SP100, the sp_dump_history system procedure supports the same functionality for cumulative dumps as for full database dumps when you specify the cumulative keyword in its @dump_type parameter.
• sp_extrapwdchecks
  sp_extrapwdchecks now allows NULL values for caller_password and loginame parameters.
• sp_helpdb
  sp_helpdb output includes information about the durability of a user-created temporary database.
• sp_helprotect
  The sp_helprotect system procedure includes the owner name in the object column for objects (tables, databases, and so on).
• sp_listener
  sp_listener adds support for the AF_UNIX protocol.
• sp_optgoal
  Adaptive Server Enterprise version 15.7 SP100 changes permission checks for sp_optgoal based on your granular permissions settings.
• sp_replication_path
  sp_replication_path supports binding, unbinding, and listing of filters.
• sp_showoptstats
  Adaptive Server 15.7 SP100 introduces a new option in the sp_showoptstats system procedure to display information about precomputed result sets.
• sp_sjobcreate and sp_sjobmodify
  sp_sjobcreate and sp_sjobmodify include the continuous_run parameter, which allows you to execute jobs from a starting time and have them run according to specified intervals until an end time.