Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Utilities Reference

UltraLite HotSync Conduit Installation utility for Palm OS (ulcond10) Next Page

UltraLite Create Database utility (ulcreate)

Creates an UltraLite database with the properties you define.


ulcreate -c "connection-string" [ options ] new-database-file

-c "connection-string"

Required. Create 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.

If you do not provide file name as a parameter in the connection string, ulcreate checks the end of the command for the file you specified as new-database-file.

-g global-ID

Set the initial database ID to the INTEGER value you assign. This initial value is used with a partition size for new rows that have global autoincrement columns. When deploying an application, you must assign a different range of identification numbers to each database for synchronization with the MobiLink server.

-o [ extended-options ]

Set extended UltraLite database creation options. See Extended creation-time options.


List the available collation sequences and exit.


List the available extended database creation options and exit. See Extended creation-time options.

-p creator-ID

Required for Palm OS. Create the database with the specified four character creator-ID of the UltraLite client application.


Run in quiet mode—do not print messages.

-t file

Specify the file containing the public trusted root certificate. This certificate is required for server authentication.


Print verbose messages.


Overwrite the database file if it exists.

-z collation-sequence

Specify the label of the collation to be used.


Create a file with the specified name. Only use this standalone file name if you are not setting a connection string to set initial database parameters like a user ID (UID) or a password (PWD). Ensure the standalone file name you set is appropriate for your platform.


If you do not set any database properties, ulcreate creates a case insensitive, non-Unicode database with a collation sequence that depends on the current locale.

Case sensitivity    Database passwords are always case sensitive, regardless of the case-sensitivity of the database. Database case sensitivity depends on whether you use the case=respect extended option setting.

About collations    The collation sequence is used for all string comparisons in the database. In UltraLite, collations include a code page plus a sort order. If you do not specify -z , ulcreate attempts to determine a reasonable collation to use based on the current locale of the desktop.

To see a list of supported collations (and its corresponding codepage), run ulcreate -l at the command prompt.

UTF-8 encoding    Determining whether or not to use the UTF-8 encoding depends on the operating system of your device.

Palm OS databases    Palm databases written to the desktop must be identified with the .pdb extension. However, once you deploy the database to the device, the extension is dropped. For more details on file name formats, see Palm OS.

Errors    This utility returns error codes. Any value other than 0 means that the operation failed.

See also

Create an UltraLite database called test.udb as a case-insensitive, non-Unicode database with a collation sequence that depends on the current locale:

ulcreate test.udb

Create a case sensitive database called test.udb so that the database is created with ISO-compatible date formatting and ordering, by executing the following command:

ulcreate -c DBF=test.udb -o case=respect -o date_format=YYYY-MM-DD -o date_order=YMD

Create an encrypted database called test.udb with the afvc_1835 encryption key:

ulcreate -c "DBF=test.udb;DBKEY=afvc_1835"