Query properties help define additional features when querying from the database. The Advanced Query Properties panel appears under query details when adding a new query. Follow the instructions in section "Handling Data Service Queries" to open the "Add New Query" page.
Available advanced query property details are described below.
Sets a timeout for the underlying JDBC query.
Forward - rows in a result set will be processed in a forward direction; first-to-last.
The number of rows that should be fetched from the database when more rows are needed.
Max Field Size
Maximum data size for the field.
Maximum number of rows to be returned. 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.