The SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY function
fetches the value of the specified property of the database on the current
connection.
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 "Enabling user
authentication" and "Setting the SQL standard authorization mode" 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');