...
Forward Only - This sets the cursor for the resultset to a forward-only cursor type, allowing one pass at data retrieval. If this is false, and the connection supports scrollable cursors, then the cursor type is scrollable, allowing multiple passes at the data. Forward only is false by default.
SQL Query - This is required if no prepared component object is defined. to utilize SQL's prepared statement functionality.
...