UltraLite Java edition database property values are defined when the database is first created. They can be changed by re-creating the UltraLite Java edition database or editing their corresponding database option, if available.
UltraLite Java edition supports the following database properties:
| Property | Description |
|---|---|
| blob_file_base_dir |
Returns the base directory the database uses to search for BLOB files. See also: |
| date_format | Returns the date format the database uses for string conversions. See UltraLite date_format creation parameter. |
| date_order | Returns the date order the database uses for string conversions. See UltraLite date_order creation parameter. |
| global_database_id | Returns the value of the global_database_id option used for global autoincrement columns. See UltraLite global_database_id option. |
| 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. |
| database_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. See UltraLite nearest_century creation parameter. |
| page_size | Returns the page size of the database, in bytes. See UltraLite page_size creation parameter. |
| precision | Returns the floating-point precision the database uses for string conversions. 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. See UltraLite scale creation parameter. |
| time_format | Returns the time format the database uses for string conversions. See UltraLite time_format creation parameter. |
| timestamp_format | Returns the timestamp format the database uses for string conversions. See UltraLite timestamp_format creation parameter. |
| timestamp_increment | Returns the minimum difference between two unique timestamps, in microseconds. See UltraLite timestamp_increment creation parameter. |
| timestamp_with_time_zone | Returns the timestamp format for TIMESTAMP WITH TIME ZONE values. See UltraLite timestamp_with_time_zone_format creation parameter. |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |