UltraLite Database User's Guide
Creating UltraLite databases and schemas
UltraLite applications require a schema definition in order to create a database. If you are using an UltraLite component, you deploy the database schema in a separate schema file. If you are using a static development model, your application contains the schema definition.
The physical storage of the UltraLite database depends on the target platform.
Palm Computing Platform The database is stored in the Palm persistent (static) memory using the Data Manager API. For devices operating Palm OS version 4.0, you can store UltraLite databases in the file-based storage of expansion cards.
For more information, see Choosing database storage on the Palm OS and Database On Palm connection parameter.
Windows and Windows CE The database is stored in the file system. On Windows CE the default file is \UltraLiteDB\ul.udb. On other versions of Windows the default file is ul_<project>.udb in the working directory of the application, where <project> is the UltraLite project name used during the development process.
You can choose to explicitly specify a database file name , or you can choose to use the default file name.
For more information, see Database On CE connection parameter.
Static Java The database is either transient, or is stored as a file in the file system. By default, it is transient.
For static APIs, you can supply parameters that control features such as database encryption on your first connection attempt (which is when the database is created). For UltraLite components, set the schema parameters of the Create Database method.
UltraLite for MobileVB See CreateDatabaseWithParms method.
UltraLite ActiveX See CreateDatabaseWithParms method.
Native UltraLite for Java See ianywhere.native_ultralite.DatabaseManager in the Native UltraLite for Java API Reference.
UltraLite.NET See ULDatabaseManager class (iAnywhere.Data.UltraLite namespace) or DatabaseManager class (iAnywhere.UltraLite namespace).
UltraLite C++ Component See Class UltraLite_DatabaseManager.
UltraLite for embedded SQL See Macros and compiler directives for UltraLite C/C++ applications.
UltraLite Static C++ See Macros and compiler directives for UltraLite C/C++ applications.
UltraLite Static Java See UltraLite API reference.
UltraLite for M-Business Anywhere See Method createDatabaseWithParms.
SQL Anywhere Studio 9.0.2
Copyright © 1989–2004 Sybase, Inc. Portions copyright © 2001–2004 iAnywhere Solutions, Inc. All rights reserved.