Table 2-9 summarizes the changes made to existing system procedures.
Procedure |
Change |
|---|---|
sp_addserver |
Adds functionality for Adaptive Server’s new limits. |
sp_dropserver |
Adds functionality for Adaptive Server’s new limits. |
sp_havrfy |
Adds functionality for Adaptive Server’s new limits. |
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_serveroption |
Supports the new external engine auto start clause, which enables or disables automatic startup of EJB Server whenever Adaptive Server starts up. The default is true. |
