DataDictionaryVersion The DataDictionaryVersion property shows the version of the on-disk data in the database. DataDictionaryVersion property database-wide propertiesretrieving database version

The version is the first two numbers (the major and minor release values) in a release identifier. For newly created databases and for soft-upgraded databases, this is the release identifier of the engine jar used to create the database. For fully upgraded databases, this is the release identifier of the engine jar used to perform a full upgrade of the database. See upgrade=true attribute for more information about upgrading databases.

You can retrieve the value of this property by using the , but you cannot change it.

Syntax -- database-level property VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('DataDictionaryVersion') Example ij> connect 'jdbc:derby:firstdb'; ij> VALUES SYSCS_UTIL.SYSCS_GET_DATABASE_PROPERTY('DataDictionaryVersion'); 1 ----------------------------------------------------------------------- 10.10 1 row selected