Micro Focus XDBC Setup: Advanced Tab

On the Advanced tab, type the following information or accept the defaults, then click OK.

Fetch Buffer Size	Specify the size of the fetch buffer in bytes. The fetch buffer indicates how much data will be fetched or retrieved from a query at a time. Allowable values are `1024` through `32766`. Default value is `4096`.
Merge Buffer Size	Specify the size of the merge buffer in rows. This is the number of unique rows that your query can return. Default value is `10,000`.
Memory Sort Pages	Specify the number of memory sort pages. This indicates how many of the Total Sort Pages will reside in memory. Allowed values are `100` to `999,999`. Default value is `1000`.
Total Sort Pages	Specify the total number of sort pages. Total sort pages is the number of virtual memory pages used to sort results sets. Allowed values are `1000` to `99,999,999`. Default value is `10,000`.
Maximum Statements	Specify the maximum number of statements allowed. Values are `10` to `4096`. Default value is `256` (See Maximum Cursors).
Maximum Cursors	Specify the maximum number of cursors allowed. Allowable values are `10` to `1024`. Default value is `64`. Micro Focus XDBC has a concept of logical cursors (nlc) that are mapped over a smaller number of actual DB Cursors (ndc). If you create fewer SQL statements equal to or less than the number of DB Cursors set, it's a straight one-to-one relationship. However, when you attempt to open more cursors, Micro Focus XDBC searches for the oldest soft-closed logical cursor that it can unhook from a database cursor and assign to the new statement. If the application tries to use the original statement, Micro Focus XDBC will look for another unused logical cursor to donate its DB Cursor. If no cursors can be unhooked (because results are pending), an error message `Too many concurrently open cursors` is returned.
Maximum Columns	Specify the maximum number of columns allowed in a single table. Allowable is `1` to `1024`. Default value is `256`. (Note that some Microsoft applications will not allow more than 256 columns in a table.)