UltraLite Database User's Guide
Using UltraLite Static Interfaces
Overview
Developing UltraLite applications using a static interface requires the following tools.
A reference database A reference database is an Adaptive Server Anywhere database that serves as a model of the UltraLite database you want to create. You create this database yourself, using tools such as Sybase Central.
Your UltraLite database is a subset of the columns, tables, and indexes, in your reference database. The arrangement of tables and of the foreign key relationships between them is called the database schema.
In addition to modeling the UltraLite database, you need to add the SQL statements that are to be included in your UltraLite application to the reference database.
For more information, see Preparing a reference database.
A supported development tool You use a standard development tool to develop UltraLite applications. For the non-UltraLite specific portions of your application, such as the user interface, use your development tool in the usual way. For the UltraLite-specific data-access portions, you also need to use the UltraLite development tools.
It can be convenient to separate the data access code from the user interface and internal logic of your application.
For information about supported application development tools, see UltraLite host platforms.
UltraLite development tools UltraLite includes several tools for development using the static interfaces.
The UltraLite generator This application generates source code that implements the underlying query execution, data storage, and synchronization features of your application. The generator is required for all kinds of UltraLite development using static SQL.
The SQL preprocessor This application is needed only if you are developing an UltraLite application using embedded SQL. It reads your embedded SQL source files and generates standard C/C++ files. As it scans the embedded SQL source files, it also stores information in the reference database that is used by the generator.
UltraLite runtime libraries UltraLite includes a runtime library for each target platform. On some platforms, this is a static library that becomes part of your application executable; on other platforms it is a dynamic link library. For Java, the runtime library is a jar file. UltraLite includes all the header files and import files needed to use the runtime libraries.