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

DB2 UDB Version 8.1 FixPak 16 (also known as Version 8.2 FixPak 9 )

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

• 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.
  

Problem conclusion

• Problem was first fixed in Version 8.1 FixPak 16
  

Temporary fix

Comments

APAR Information

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

  LI72544

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

  LI73188

Fix information

• Fixed component name

  DB2 UDE ESE LIN

• Fixed component ID

  5765F4104

Applicable component levels

• R820 PSN

     UP