LI72544: SAME STATEMENT NAME IN MORE THAT ONE DYNAMIC CURSOR DECLARATION IN SAME SQL PROCEDURE CAUSES REBIND COMMAND TO FAIL.

DB2 Version 9.1 Fix Pack 7  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 5   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6   for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 6a for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 7a  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 8  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 9  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

APAR status

• Closed as program error.

Error description

• Same statement name in more that one dynamic cursor declaration
  in same SQL procedure causes rebind command to fail. This is
  documented as a restriction but it is not enforced during
  compilation time.
  
  From DB2 Reference for Dynamic Cursor -
  
  statement-name
  The SELECT statement of the cursor is the prepared SELECT
  statement identified by the statement-name when the cursor is
  opened. The statement-name must not be identical to a
  statement-name specified in another DECLARE CURSOR statement of
  the source program
  

Local fix

• Change dynamic cursor declarations so that all statement names
  are unique within a SQL procedure.
  

Problem summary

• Users affected: All
  Problem summary: SAME STATEMENT NAME IN MORE THAT ONE DYNAMIC
  CURSOR DECLARE IN THE SAME SQL PROCEDURE CAUSES REBIND COMMAND
  TO FAIL.
  Problem Details: see Problem Summary
  

Problem conclusion

• First fixed in v9.1 Fp5
  

Temporary fix

• Use different cursor names
  

Comments

APAR Information

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

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

  LI72587

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R910 PSY

     UP