Built-in system functions

This section describes the different built-in system functions available with Derby.

• SYSCS_UTIL.SYSCS_CHECK_TABLE system function
  The SYSCS_UTIL.SYSCS_CHECK_TABLE function checks the specified table, ensuring that all of its indexes are consistent with the base table.
• SYSCS_UTIL.SYSCS_GET_DATABASE_NAME system function
  The SYSCS_UTIL.SYSCS_GET_DATABASE_NAME function returns the name of the database of the current connection.
• 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.
• SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS system function
  The SYSCS_UTIL.SYSCS_GET_RUNTIMESTATISTICS function returns a VARCHAR(32672) value representing the query execution plan and runtime statistics for a java.sql.ResultSet.
• SYSCS_UTIL.SYSCS_GET_USER_ACCESS system function
  The SYSCS_UTIL.SYSCS_GET_USER_ACCESS function returns the current connection access permission for the user specified.
• SYSCS_UTIL.SYSCS_GET_XPLAIN_MODE system function
  The SYSCS_UTIL.SYSCS_GET_XPLAIN_MODE function returns the current XPLAIN mode.
• SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA system function
  The SYSCS_UTIL.SYSCS_GET_XPLAIN_SCHEMA function returns the XPLAIN schema for the connection.
• SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY system function
  The SYSCS_UTIL.SYSCS_PEEK_AT_IDENTITY function allows users to observe the next value which will be issued for an identity column.
• SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE system function
  The SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE function allows users to observe the instantaneous current value of a sequence generator without having to query the SYSSEQUENCES system table.