If the value that was set for the property is invalid, the
SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY function returns the
invalid value, but uses
the default value.
Syntax VARCHAR(32672) SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY(IN KEY VARCHAR(128)) An
error will be returned if KEY is null.
Execute privileges
If authentication and SQL authorization are both enabled, only the
database owner has
execute privileges on this function by default. See "Configuring user
authentication" and "Configuring user authorization" in the
for more information. The
database owner can grant access to other users.
SQL example Retrieve the value of the
derby.locks.deadlockTimeout property:
VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('derby.locks.deadlockTimeout');