Database-wide properties, which affect a single database, are stored within the database itself. This allows different databases within a single Derby system to have different properties and ensures that the properties are correctly set when a database is moved away from its original system or copied.
- You should use database-wide properties wherever possible for ease of deployment.
To set a property, you connect to the database, create a statement, and then use the SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY procedure, passing the name of the property and the value.
If you specify an invalid value, Derby uses the default value for the property.
See the Derby Reference Manual for more information on how to use these system functions and procedures.
Table of Contents