[SYBASE], [ORACLE]
max_statements=64
This is the maximum number of cursors that auxoracl or auxsybas will attempt to open per connection before it begins to close cursors to free up some for reuse.
The advantage of having this reasonably high is that it may be possible to reuse existing prepared SQL statements. The amount of reuse possible varies according to the database in use.
Note that this value is not used with auxwodbc because there is a per database way to specify the number of statements to keep for this program. See statements.
Prior to build 96 of AUXORACL, this value was in fact counted up on a per table rather than per connection basis. This meant it did not work as intended and the maximum number of cursors might be exceeded. This problem has now been fixed. On Oracle, you are recommended to specify a value for max_statements that it is only slightly less than the value specified for open_cursors in the initdbname.ora file for the Oracle database (which you can edit and increase to a larger value if required) .
If the SQL database reports that the maximum number of cursors has been exceeded DP4 will silently close old cursors and reduce the value of max_statements that applies to that database.