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.)