skip to main content
OpenEdge Data Management: DataServer for ODBC
Troubleshooting : Tuning your environment with the -Dsrv startup parameter : Using ODBC and DataServer options : Cursor characteristics: The PRGRS_STABLE_CURS option
 
Cursor characteristics: The PRGRS_STABLE_CURS option
The ODBC driver and its data source ultimately determine whether a cursor is stable during the commit or rollback of a transaction and if the cursor can persist beyond a single transaction scope. The DataServer normally resolves cursor characteristics by interrogating the driver and setting the run-time environment accordingly. OpenEdge does not recommend bypassing normal operation under most circumstances. However, if your driver and/or data source do not provide stable cursors, then under very specific circumstances, you might improve performance by setting the PRGRS_STABLE_CURS option to 1 (on). If all the ABL you run in your OpenEdge DataServer session is without transactions or if all of its queries and resultant data sets are fully processed on one or the other side of any existing transaction boundaries, setting this option is possible.
Note: This is a session-level switch which means all ABL run in that session must comply with the above requirements.