UltraLite database properties

Property Description
case Returns the status of the case sensitivity feature. Returns On if the database is case sensitive. Otherwise, it returns Off. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite case creation parameter.
char_set

Returns the CHAR character set of the database. The character set used by the database is determined by the database's collation sequence and whether the data is UTF-8 encoded.

See also:

The value of this property is set when the database is created, and can only be changed by creating a new database.

checksum_level Returns the level of checksum validation in the database, one of 0 (do not add checksums), 1 (add checksums only to important pages), or 2 (add checksums to all pages). The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite checksum_level creation parameter.
collation Returns the name of the database's collation sequence. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite collation creation parameter.
commit_flush_count Returns the value of the commit_flush_count option that sets a commit count threshold. See UltraLite commit_flush_count option [temporary].
commit_flush_timeout Returns the value of the commit_flush_timeout option that sets a time interval threshold. See UltraLite commit_flush_timeout option [temporary].
conn_count Returns the number of connections to the database. The value is dynamic: it can vary depending on how many connections currently exist. UltraLite supports up to fourteen concurrent database connections.
date_format Returns the date format the database uses for string conversions. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite date_format creation parameter.
date_order Returns the date order the database uses for string conversions. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite date_order creation parameter.
encryption

Returns the type of database encryption, one of None, Simple, AES, or AES_FIPS.

The encryption used by the database is determined by whether or not you have configured strong encryption (AES or AES_FIPS) and the DBKEY creation parameter, or obfuscation (simple encryption).

The only time this property can change is when the value is originally None (that is, neither fips nor obfuscation is used) and you then change the encryption key by specifying a new encryption key on the Connection object by calling the correct function or method for your API. In this case, the value would change to AES because the fips creation parameter cannot be set after the database has been created. See:

file

Returns the name of the database root file for the current connection, the including path. This is the value specified in the DBF connection parameter value. See:

global_database_id Returns the value of the global_database_id option used for global autoincrement columns. See UltraLite global_database_id option.
max_hash_size Returns the default number of maximum bytes to use for index hashing. This property can be set on a per-index basis. See UltraLite max_hash_size creation parameter.
ml_remote_id Returns the value of the ml_remote_id option that uniquely identifies the database for MobiLink synchronization. See UltraLite ml_remote_id option.
name

Returns the name (or alias) of the database for the current connection. The name returned matches the DBN connection parameter value. If you did not use the DBN connection parameter, the name returned is the database file without the path and extension.

See also:
nearest_century Returns the nearest century the database uses for string conversions. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite nearest_century creation parameter.
page_size Returns the page size of the database, in bytes. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite page_size creation parameter.
precision Returns the floating-point precision the database uses for string conversions. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite precision creation parameter.
scale Returns the minimum number of digits after the decimal point when an arithmetic result is truncated to the maximum PRECISION during string conversions by the database. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite scale creation parameter.
time_format Returns the time format the database uses for string conversions. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite time_format creation parameter.
timestamp_format Returns the timestamp format the database uses for string conversions. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite timestamp_format creation parameter.
timestamp_increment Returns the minimum difference between two unique timestamps, in microseconds. The value of this property is set when the database is created, and can only be changed by creating a new database. See UltraLite timestamp_increment creation parameter.

Accessing UltraLite database properties

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1