[Download] | [Documentation Home] | [Release Note]
Introduction
Advanced query properties helps users to define additional properties when querying from the database.
These query properties comes under query details page.
Available advanced query property details are described below.
Property Name | Description |
Timeout | Set a timeout for the underlying JDBC query |
Fetch Direction | Forward - The rows in a result set will be processed in a forward direction; first-to-last
Backward - rows in a result set will be processed is unknown |
Fetch Size | The number of rows that should be fetched from the database when more rows are needed. If the fetch size specified is zero, the JDBC driver ignores the value and is free to make its own best guess as to what the fetch size should be. |
Max Field Size | Maximum data size for the field. This use to reduce the size each field takes up to reduce or eliminate the possibility of running into a db limit |
Max Rows | Maximum number of rows to be return. Zero means all rows |
Force Stored Procedure | Forces the current sql statement as a stored procedure |
Force JDBC Batch Requests | Forces to use native jdbc batch request |