SYSCS_UTIL.SYSCS_UPDATE_ALL_SYSTEM_PROCEDURES system procedure
updates the signatures of all of the system procedures in a database.
You need to call this procedure when you update to a new version of Splice Machine that includes new or updates system procedure signatures.
About System Procedures
Splice Machine uses prepared statements known as system procedures to access data in the system tables. Each system procedure has two parts:
- An implementation, which is compiled Java byte code that is stored in the Splice jar and is included in the CLASSPATH of the Splice server.
- A declaration (or signature), which is a CREATE PROCEDURE statement that is stored in the Splice jar file and is synchronized with the data dictionary (in the SYSALIASES table).
SYSALIASES table is synchronized with a database when the database
is first created. Thereafter, when you make changes to the system
procedures, you need to call a function to keep the
synchronized with the procedures in the Splice jar file.
If you’ve modified, deleted, or added a system procedure, call the
function, which drops the procedure from the data dictionary, and
updates the dictionary with the new version in the Splice jar file.
If you’ve made multiple modifications to the system procedures, you can
call this function,
SYSCS_UTIL.SYSCS_UPDATE_ALL_SYSTEM_PROCEDURES , to
update all of the stored declarations for a database in the data
dictionary. This function drops all of the system procedures from the
data dictionary and then recreates the system procedures stored in the
dictionary from the definitions in the Splice jar file.
This procedure does not return a result.
A string specifying the name of the schema that needs to be updated in the data dictionary.
splice> call SYSCS_UTIL.SYSCS_UPDATE_ALL_SYSTEM_PROCEDURES('SYSCS_UTIL'); Statement executed.