PI36231: FOR UPDATE STATEMENTS NOT CORRECTLY HANDLED IN GENERATED JAVA

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

• for update statements are not being correctly handled in the
  generated Java as per the following sample:
  open associazioniVociMenuRs for associazioniVociMenuRec
  forUpdate with
          #sql{
                  select
                          CD_MENU, CD_VOCE_MENU
                  from HP_ASSOCIAZ_VOCI_MENU
                  where CD_MENU = :associazioniVociMenuRec.CD_MENU
                  order by
                          CD_MENU, CD_VOCE_MENU asc
                  for update
          };
  
  In the above scenario the "for update" is ignored in Java
  generation and such clauses are not being handled whereas if the
  above included as a "for update of" clause these are correctly
  generated.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * EGL Java and Debugger user who use explicit with forUpdate   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The for update in #sql statement is ignored in EGL Java and  *
  * Debugger                                                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The problem is fixed.
  

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

• R950 PSY

     UP