Changed system procedures

Table 6 summarizes the changes made to existing system procedures.

Table 6: Changed system procedures

Procedure

Change

sp_helpjava

Supports the new depends keyword, which allows you to view a list of database objects that depend on the specified Java class or JAR.

sp_configure

sp_configure allows you to specify the value for configuration paramters in unit specifiers. The unit specifiers are p or P for pages, m or M for megabytes, and g or G for gigabytes. sp_configure also reports on whether the parameter is static or dynamic, and the units for each option.

sp_serveroption

Supports the new external engine auto start clause, which enables or disables automatic start-up of EJB Server whenever Adaptive Server starts up. The default is true.