PI30028: [WI 22026] RBD 9.1 DYNAMIC INSERT SQL ERROR IN DEBUG MODE

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

APAR status

• Closed as program error.

Error description

• Debug EGL code with dynamic inset SQL in RBD 9.1 results in
  error as the 'Prepare' statement is skipped and process jump to
  on exception.
  
  WI =>
  https://l2l3-cmn-rtc.ratl.swg.usma.ibm.com:9443/ccm/web/projects
  /Rational%20Escalation#action=com.ibm.team.workitem.viewWorkItem
  &id=22026
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Debug EGL code with dynamic inset SQL in RBD 9.1 results in  *
  * error as the 'Prepare' statement is skipped and process jump *
  * to                                                           *
  * on exception.                                                *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Debug  egl  program by using  " " (blank string) after       *
  * "from" statement                                             *
  * ie.  try                                                     *
  *     prepare XXX from                                         *
  *         " " + XXX                                            *
  *       for XXX ;                                              *
  * it will cause a  exception.                                  *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• the problem is fixed in the RBD 9.1.1 and  will be fixed the new
  version after RBD 9.0.1
  

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