PI30696: SQL CLOSE IS NOT BEING DONE ON THE CURSOR WHEN MORE THAN 1 MULTI-ROW CURSOR IS DEFINED

Rational Business Developer Fix Pack 1 (9.0.1.1) for 9.0.1
Rational Business Developer 9.5.0.1
Rational Business Developer Fix Pack 1 (9.1.1.1) for 9.1.1
Rational Business Developer 9.5.1
Rational Business Developer Fix Pack 2 (9.0.1.2) for 9.0.1

APAR status

• Closed as program error.

Error description

• Attempts to do two multiple row fetch with two open cursor using
  IBM Rational Business Developer cause program loop on the first
  fetch.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users that have multiple opens against the same record and   *
  * also using rowset.                                           *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The sql cursor is being left open if multiple open           *
  * statements are created against the same array of records     *
  * that also use rowset.                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• This fix will cause the cursor to get closed at the appropriate
  time.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  RATL BUS DEV

• Fixed component ID

  5724S5000

Applicable component levels

• R901 PSY

     UP

• R911 PSY

     UP