Properties

Statement properties affect the behavior of the statement. Statement properties can be set when a statement is first created or when a Statement is executed.

Examples of the properties that can be set are:
  • Query prefetch - Number of rows to return in a batch when a query is first executed and each time more rows are requested while iterating through the results.
  • Query fetch timeout - Number of seconds to wait for a batch of rows to be returned before the method waiting for the rows time out.
For specific information about Statement properties, see each language API's documentation for the following tasks:
  • Creating a Statement from a Session object
  • Executing a query by using a Statement object
  • Executing a DML command by using a Statement object
Related concepts