Lifecycle of a Query—Use of Query Functions

Lifecycle of a query involves creation, execution, and gathering of results. Functions can be used to create and execute queries, and to gather query results.

Also see Result Set Data Usage (Snapshot Queries) and Callback Rule Function Data Usage for details on how to get and use query results.

  • Query Definition Creation
    A query definition is a Java runtime object (similar to a factory class).
  • Query Statement Opening
    A query statement is an object that represents one instance of the query. You can create multiple statements that can run in parallel.
  • Bind Variables Value Setting (if Used)
    For the named query statement, set values for bind variables (if any are used in the query definition) before executing them. This sequence is required.
  • Query Statement Execution
    To execute a query and specify how a query returns values, you can use either of the execute functions.
  • Statement Closing and Query Definition Deletion
    You can close or delete at different levels. You can delete a query definition to make room for new query definitions. You can also delete (close) the statement that is running, without deleting the query definition itself.