For information about properties, see
.
Syntax
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(IN KEY VARCHAR(128),
IN VALUE VARCHAR(32672))
This procedure does not return any results.
If VALUE is not null, then the property with key value KEY is set to VALUE.
If VALUE is null, then the property with key value KEY is deleted from the
database property set.
If VALUE is an invalid value for the property,
uses the default value
of the property, although
SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY sets the invalid
value.
Execute privileges
If authentication and SQL authorization are both enabled, only the
database owner has
execute privileges on this procedure by default. See "Configuring user
authentication" and "Configuring user authorization" in the
for more information. The
database owner can grant access to other users.
JDBC example Set the
derby.locks.deadlockTimeout property
to a value of 10:
CallableStatement cs = conn.prepareCall
("CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY(?, ?)");
cs.setString(1, "derby.locks.deadlockTimeout");
cs.setString(2, "10");
cs.execute();
cs.close();
SQL example Set the derby.locks.deadlockTimeout property
to a value of 10:
CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY
('derby.locks.deadlockTimeout', '10')