PL46637: RC00E70005 IN DSNXESX DURING BIND

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• ABEND04E RC00E70005 DSNXESX DURING BIND OF FOLLOWING SQL STMT:
  EXEC SQL
       UPDATE DVFTG
       SET IDORGT = IDORG,
           BENAMT = BEFTG
           WHERE IDHC = :WT50-IDHC AND
                 IDFTG = : WT50-IDFTG
  END-EXEC
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: ALL.                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION: ABEND04E RC00E70005 IN MODULE DSNXESX   *
  *                      DURING BIND.  THE APPLICATION           *
  *                      CONTAINED AN UPDATE STATEMENT WITH      *
  *                      TWO PREDICATES.  THE COLUMNS IN THE     *
  *                      PREDICATES WERE DEFINED WITH A          *
  *                      FIELDPROC.  WITHOUT THE FIELDPROC,      *
  *                      THE APPLICATION BOUND SUCCESSFULLY.     *
  ****************************************************************
  * RECOMMENDATION: APPLY PTF WHEN AVAILABLE.                    *
  ****************************************************************
  ABEND04E RC00E70005 IN MODULE DSNXESX DURING THE BIND.  THE
  APPLICATION CONTAINED AN UPDATE STATEMENT WITH A WHERE CLAUSE
  THAT REFERENCED COLUMNS DEFINED WITH A FIELDPROC. WHEN THE
  FIELDPROC WAS REMOVED, THE BIND WAS SUCCESSFUL. THE DYNAMIC
  VARIABLE FLAG IN MODULE DSNXGMVE WAS NOT SET PROPERLY. THIS
  CAUSED A RELOCATION PROBLEM TO BE GENERATED AND EVENTUALLY THE
  ABEND.
  

Problem conclusion

• DSNXGMVE HAS BEEN CHANGED TO SET THE DYNAMIC VARIABLE FLAG
  DVAR PROPERLY.
  ADDITIONAL KEYWORDS: SQLWHERE SQLUPDATE
  

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:

  UL59533 UL59534 UL59535

Modules/Macros

•    DSNXGMVE
  

Fix information

• Fixed component name

  5740 IBM DATABA

• Fixed component ID

  5740XYR00

Applicable component levels

• R210 PSY UL59535

     UP89/09/25 P F908

• R220 PSY UL59534

     UP89/09/25 P F908

• R302 PSY UL59533

     UP89/09/26 P F908

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.