UltraLite User's Guide
Introduction to UltraLite
UltraLite architecture
The UltraLite development tools supplement a supported C/C++ or Java development tool. They manage the generation of the data access code for your application.
During UltraLite application development you create an Adaptive Server Anywhere reference database, which is a model of your UltraLite database. You use the UltraLite generator, which uses the reference database to create the data access and data management code for your application.
The SQL statements used in the application must be determined at compile time. In other words, you cannot dynamically construct a SQL statement within an UltraLite application and execute it. However, SQL statements in UltraLite applications can use placeholders or host variables to adjust their behavior.