IBM Support

IC65641: AMBIGUOUS CURSOR IS DELETABLE BUT NOT UPDATABLE

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as Permanent restriction.

Error description

  • Description: DECLARE CURSOR results in an ambiguous cursor if
    each of the following are true:
                  -
    the select-statement is dynamically prepared        -
    the select-statement does not include either the FOR READ
    ONLYclause or the FOR UPDATE clause
       - the LANGLEVEL bind option is SAA1
      - the cursor otherwise satisfies the conditions of a deletable
     cursor
    
    If the static package is bound with BLOCKING UNAMBIG or
    BLOCKING NO, the cursor should be updatable but it is not, it is
    only marked as deletable.
    

Local fix

  • If the cursor needs to be updatable, either add a FOR UPDATE
    clause to the query or change the LANGLEVEL bind option to MIA
    or SQL92E.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * DECLARE CURSOR results in an ambiguous cursor                *
    * if each of the following are true:                           *
    *                                                              *
    * - the select-statement is dynamically prepared               *
    * - the select-statement does not include either the FOR READ  *
    * ONLY clause or the FOR UPDATE clause                         *
    * - the LANGLEVEL bind option is SAA1                          *
    * - the cursor otherwise satisfies the conditions of a         *
    * deletable cursor                                             *
    *                                                              *
    * If the static package is bound with BLOCKING UNAMBIG or      *
    * BLOCKING NO, the cursor should be updatable but it is not,   *
    * it is only marked as deletable.                              *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * If the cursor needs to be updatable, either add a FOR UPDATE *
    * clause to the query or change the LANGLEVEL bind option to   *
    * MIA or SQL92E.                                               *
    ****************************************************************
    

Problem conclusion

  • Permanent restriction
    

Temporary fix

Comments

  • This will be a permanent Restriction and not fixed.
    

APAR Information

  • APAR number

    IC65641

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    950

  • Status

    CLOSED PRS

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-01-18

  • Closed date

    2010-05-26

  • Last modified date

    2010-05-26

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

    IC64436

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

Fix information

Applicable component levels

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.5","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
26 May 2010