SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY system function

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 Derby 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 Derby Developer's Guide 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');