PK89571: 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: 1. FFit of OMPE V410 APAR PK88115.      *
  *                         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).             *
  *                                                              *
  *                      2. FFit of OMPE V410 APAR PK90085.      *
  *                         EXPLAINing SQL statement text        *
  *                         entered by OLM option 9.4 and having *
  *                         a stmt structure "UPDATE table1 ...  *
  *                         SELECT ... FROM table2 ..." results  *
  *                         in message FPEM760                   *
  *                         (The SQL statement is not recognized *
  *                         or cannot be explained).             *
  ****************************************************************
  * RECOMMENDATION: Apply this PTF                               *
  ****************************************************************
  PROBLEM SUMMARY:
  1. FFit of OMPE V410 APAR PK88115.
     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).
  
  2. FFit of OMPE V410 APAR PK90085.
     EXPLAINing SQL statement text entered by OLM option 9.4
     and having a stmt structure
     "UPDATE table1 ... SELECT ... FROM table2 ..."
     results in message FPEM760
     (The SQL statement is not recognized or cannot be explained).
  
  PROBLEM CONCLUSION:
  1. FFit of OMPE V410 APAR PK88115.
     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
  
  2. FFit of OMPE V410 APAR PK90085.
     Code was changed to display a SQL error panel if the object
     table1 or table2 can not be found in the database.
  
  KEYWORDS:
  EXPLAIN SQLTEXT FPEM760 HOSTVAR BLANK UNQUALIFIED-TABLE
  

Problem conclusion

• PROBLEM CONCLUSION:
  1. FFit of OMPE V410 APAR PK88115.
     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
  
  2. FFit of OMPE V410 APAR PK90085.
     Code was changed to display a SQL error panel if the object
     table1 or table2 can not be found in the database.
  
  KEYWORDS:
  EXPLAIN SQLTEXT FPEM760 HOSTVAR BLANK UNQUALIFIED-TABLE
  

Temporary fix

Comments

APAR Information

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

  PK88115

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

  UK48260

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 HKDB420J KDB420J
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R420 PSY UK48260

     UP09/07/14 P F907

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.