Native UltraLite for Java User's Guide
Understanding UltraLite Development
UltraLite supports dynamic SQL for accessing data in tables. This section describes the programming interface to access dynamic SQL features, including the following topics:
Inserting, deleting, and updating rows.
Retrieving rows to a result set.
Scrolling through the rows of a result set.
This section does not describe the SQL language itself. For information about dynamic SQL features, see Dynamic SQL.
The sequence of operations required is similar for any SQL operation. For an overview, see Using dynamic SQL.
Data manipulation: INSERT, UPDATE and DELETE
Data retrieval: SELECT
Navigating through dynamic SQL result sets
Result set schema description