PM23465: SQLCODE206 WHEN EXPLAINING WITH DASH '-' IN HOST VARIABLE

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This one explains fine:
  SELECT *
  FROM SYSIBM.SYSTABLES
  WHERE NAME = :WS
  
  This one fails with a -206 SQLcode:
  SELECT *
  FROM SYSIBM.SYSTABLES
  WHERE NAME = :W-S
  .
  The hyphen (or dash) is where the problem comes in.  We want to
  use this feature in ISPF while editing COBOL source code.  Our
  typical host variables have hyphen in them.  Therefore, this is
  a big problem for us.  COBOL SQL works fine as long as there are
  no hyphens in the host variables.  We are trying to get off of
  an old, unsupported Explain tool that we used in this way and we
  want to use OMPE for this function.
  

Local fix

• N/A
  

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 ":A-B"            *
  *                      (dash in the host variable name)        *
  *                      results in SQLCODE -206.                *
  ****************************************************************
  * 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
  ":A-B" (dash in the host variable name) results in SQLCODE -206.
  
  PROBLEM CONCLUSION:
  Cobol host variable name with a dash in the name is allowed.
  
  KEYWORDS:
  EXPLAIN COBOL HOSTVAR DASH
  

Problem conclusion

• Cobol host variable name with a dash in the name is allowed.
  
  KEYWORDS:
  EXPLAIN COBOL HOSTVAR DASH
  

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:

  UK62515

Modules/Macros

• DGOYU213
  

Fix information

• Fixed component name

  OM XE DB2PE/PM

• Fixed component ID

  5655OPE00

Applicable component levels

• R420 PSY UK62515

     UP10/11/25 P F011

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.