|
This utility performs the following functions:
Displays information about an UltraLite database.
Changes or clears the global_id or ml_remote_id database options.
ulinfo -c "connection-string" [ options ]
|
Option |
Description |
|---|---|
| -c "connection-string" |
Required. Connect to the database as identified in the DBF or file_name parameter of your connection-string. If you do not specify both a user ID and a password, the default UID of DBA and PWD of sql are assumed. |
| -g ID |
Set the initial global database ID to the value you assign. This value is used by the database for all new rows that have global autoincrement columns. The database uses this base value to autoincrement IDs associated with each additional row and/or column. When deploying an application, you must assign a different identification number to each database for synchronization with the MobiLink server. |
| -or |
Open the database in read-only mode. UltraLite makes a copy of the original file, which you can then use to test your scripts without altering the database. Changes to the copied file are discarded upon completion. If you are connecting directly from the desktop to a database already deployed to a CE device, this option is not supported. |
|
-q |
Run in quiet mode—do not print messages. |
| -r ID |
Set the initial ml_remote_id to the value you assign. By default, new UltraLite databases set the MobiLink remote ID to NULL. You can keep this default if you choose: both UltraLite and dbmlsync automatically set the MobiLink remote ID to a unique user ID (UUID) at the start of synchronization. |
| -rc |
Clear the existing remote database ID and set the MobiLink remote ID to NULL. |
| -v |
Print verbose messages. Display current database properties in addition to the database internals for the named database. |
Warning messages generated when opening an UltraLite database are always displayed unless you use the -q option.
Show basic database internals for a file named sample.udb that has already been synchronized:
ulinfo -c DBF=sample.udb
SQL Anywhere UltraLite Database Attribute Utility Version 10.0.0.xxxx Database name: cv_dbattr Disk file 'run\script\cv_dbattr.udb'
Collation: 1252LATIN1
Number of Users: 1
1. User: 'DBA'
Page size: 4096
Remote ID: JohnD
Global database ID: 1000
Global autoincrement usage: 0%
Number of tables: 3
Number of columns: 7
Number of publications: 3
Number of tables that will always be uploaded: 0
Number of tables that are never synchronized: 0
Number of primary Keys: 3
Number of foreign Keys: 0
Number of indexes: 0 Last synchronization completed successfully
Download occurred: 2005-12-07 15:01:28.615000
Upload OK
Upload rows not ignored
Partial download retained for subsequent sync
Actual MobiLink Authentication value: 1000
Authentication valid
Synchronization by publication number:
1. Publication cv_sync
Mask: 0x01
Number of rows in next upload: 0
Last download: 1900-01-01 00:00:00.000
2. Publication cv_syncPub2
Mask: 0x02
Number of rows in next upload: 0
Last download: 1900-01-01 00:00:00.000
3. Publication cv_syncPub3
Mask: 0x04
Number of rows in next upload: 0
Last download: 1900-01-01 00:00:00.000
Show database internals for a file named CustDB.udb and display database properties by enabling verbose messaging:
ulinfo -c DBF=CustDB.udb -v
SQL Anywhere UltraLite Database Attribute Utility Version 10.0.0.xxxx
Database information
Database name: custdb
Disk file 'C:\Documents and Settings\All Users\Shared Documents\SQL Anywhere 10\Samples\UltraLite\CustDB\custdb.udb'
Collation: 1252LATIN1
Number of Users: 1
1. User: 'DBA'
Page size: 4096
Default index maximum hash size: 8
Checksum level: 0
MobiLink Remote ID: not set
Global database ID: not set
Encryption: None
Character encoding set: 1252LATIN1
Case sensitive: OFF
Date format: YYYY-MM-DD
Date order: YMD
Nearest century: 50
Numeric precision: 30
Numeric scale: 6
Time format: HH:NN:SS.SSS
Timestamp format: YYYY-MM-DD HH:NN:SS.SSS
Timestamp increment: 1
Number of tables: 6
Number of columns: 16
Number of publications: 1
Number of tables that will always be uploaded: 0
Number of tables that are never synchronized: 1
Number of primary Keys: 6
Number of foreign Keys: 2
Number of indexes: 3
This database has not yet been synchronized.
Synchronization by publication number:
1. Publication test
Mask: 0x01
Number of rows in next upload: 0
Last download: 1900-01-01 00:00:00.000
Done.
Clear the ml_remote_id for a file called sample.udb:
ulinfo -c DBF=sample.udb -rc