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