Precompiled Statements

A precompiled statement is a named query that can be executed by using this name. The query must be a DML statement, i.e. DELETE, INSERT, SELECT or UPDATE, or a SET or CALL statement. When the statement is created a compiled version of the query is stored in the data dictionary. Precompiled statements are primarily intended for use in mobile and embedded environments in which no SQL compiler is available due to limited memory resources.