A_SYB_CURSOR_OPTION_1, A_SYB_CURSOR_OPTION_2, A_SYB_CURSOR_OPTION_3

These configuration variables allow you to fine-tune the declaration of cursors in the Acu4GL for Sybase product. In general, cursors are declared with the following syntax:

DECLARE cursor_name option_1 CURSOR option_2 FOR  
   <select....> option_3

In other words, different phrases can go in each of the option_X places. Also, different versions of Sybase allow different options in each of those places. Because of this, the Acu4GL product allows customization of the cursor declaration via these three variables. The values of these variables are placed verbatim into the declare phrase when building a cursor. Note that any errors in the values of these variables may make your Acu4GL product inoperable. You should refer to the Sybase documentation to determine what phrases are allowed in each case.

The default values are as follows (limit is 65 characters for each option):

Users of Sybase version 11 should set the value of OPTION_3 to "at isolation read uncommitted" to prevent page locks.