Retain cursor positions

 

You can improve performance by retaining cursor positions.

• Retaining cursor positions for non-ILE program calls
  For non-ILE program calls, the close SQL cursor (CLOSQLCSR) parameter allows you to specify the scope of the following:

• Retaining cursor positions across ILE program calls
  For ILE program calls, the close SQL cursor (CLOSQLCSR) parameter allows you to specify the scope of the following:

• General rules for retaining cursor positions for all program calls
  When using programs compiled with either CLOSQLCSR(*ENDPGM) or CLOSQLCSR(*ENDMOD), a cursor must be opened every time the program or module is called, in order to access the data. If the SQL program or module is going to be called several times, and you want to take advantage of a reusable ODP, then the cursor must be explicitly closed before the program or module exits.

 

Parent topic:

Application design tips for database performance