PK88115: USING EXPLAIN OPTION 9.4 IN ISPF OLM USING HOST VARIABLES IN THEFORM OF ": H" RESULTS IN FPEM760 ERROR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• EXPLAINing dynamic SQL statement text coming from a thread or
  entered by OLM option 9.4 and having host variables of the form
  ": H" (blank between the letter colon and H) results in message
  FPEM760 (The SQL statement is not recognized or cannot be
  explained.
  .
  (Only SELECT, INSERT, UPDATE, and DELETE statements can
  be explained).
  .
  

Local fix

• The internal SQLCODE is -104.
  
  The ": H" must be converted to "?" before calling the SQL stmt
  EXPLAIN. This conversion is not done correctly.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: OMEGAMON XE for DB2 PE/DB2PM                 *
  *                 users of component                           *
  *                 - Explain                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: EXPLAINing dynamic SQL statement text   *
  *                      coming from a thread or entered by OLM  *
  *                      option 9.4 and having host variables of *
  *                      the form ": H" (blank between the       *
  *                      letter colon and H) results in message  *
  *                      FPEM760 (The SQL statement is not       *
  *                      recognized or cannot be explained).     *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  EXPLAINing dynamic SQL statement text coming from a thread or
  entered by OLM option 9.4 and having host variables of the form
  ": H" (blank between the letter colon and H) results in message
  FPEM760 (The SQL statement is not recognized or cannot be
  explained).
  
  PROBLEM CONCLUSION:
  Host variables in the SQL text are translated to "?" before
  calling the DB2 EXPLAIN stmt.
  Possible host variable formats are:
  - ":H"      : Normal name without blank
  - ": H"     : Normal name with blank
  - ":H :H"   : Hostvar and Null-Indicator
  - ":abc"    : Individual name
  - ":tab.c1" : Individual name with dot
  - "? ?"     : PREPARE format or source input
  
  KEYWORDS: EXPLAIN SQLTEXT FPEM760 HOSTVAR BLANK
  

Problem conclusion

• PROBLEM CONCLUSION:
  Host variables in the SQL text are translated to "?" before
  calling the DB2 EXPLAIN stmt.
  Possible host variable formats are:
  - ":H"      : Normal name without blank
  - ": H"     : Normal name with blank
  - ":H :H"   : Hostvar and Null-Indicator
  - ":abc"    : Individual name
  - ":tab.c1" : Individual name with dot
  - "? ?"     : PREPARE format or source input
  
  KEYWORDS: EXPLAIN SQLTEXT FPEM760 HOSTVAR BLANK
  

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:

  UK47524 PK89571

Modules/Macros

•    DGO@FIST DGO@MAIN DGO@SEEE DGO@SPCK DGO@XPLC
  DGO@YEDY DGO@YX00 DGOMYEDS DGOMYEDY DGOMYGSQ DGOMYX00 DGOYFIST
  DGOYMAIN DGOYSEEE DGOYSPCK DGOYU212 DGOYU213 DGOYXPLC FPEUFLSP
  FPEUFLS2 HKDB410J KDB410J
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R410 PSY UK47524

     UP09/06/18 P F906

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.