PH24401: IMPROVE DIAGNOSTIC MESSAGES FOR SQL ERRORS (IGYPSNNNN)

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Improve Diagnostic messages for SQL errors (IGYPSnnnn)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Enterprise COBOL for z/OS V6.2      *
  *                 compiling Db2 programs with the SQL          *
  *                 compiler option (Integrated SQL coprocessor) *
  *                 who have syntax errors in the host variable  *
  *                 declarations.                                *
  ****************************************************************
  * PROBLEM DESCRIPTION: There are several different types of    *
  *                      errors in host variable declarations    *
  *                      that all generate the same error        *
  *                      message, "IGYPS0212-S SQL host variable *
  *                      reference "yournamehere" had invalid    *
  *                      syntax", but no details are provided to *
  *                      help customers fix their specific       *
  *                      problem.                                *
  ****************************************************************
  * RECOMMENDATION: Install the provided PTFs and recompile.     *
  ****************************************************************
  The compiler was using a single error message for 3 different
  syntax errors instead of giving as much details as possible to
  help programmers resolve the issue.
  

Problem conclusion

• Two new error messages were added to give more details when a
  host variable is used that has level 49 or has a contained
  filler item, new message 0293: ( SQL host variable reference
  "&1" was defined with level number 49 which is not valid for an
  SQL host variable. The statement was discarded. );
  and new message 0294: ( SQL host variable reference "&1" was
  defined with a contained "" data item, which
  is not valid for an SQL host variable.  The statement was
  discarded. );
  

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:

  PH25221

Modules/Macros

• IGY8RWTU IGYCASMB IGYCCBE  IGYCCCRT IGYCCICS IGYCCSRV IGYCDGEN
  IGYCDIAG IGYCDMAP IGYCEN$0 IGYCEN$1 IGYCEN$2 IGYCEN$3 IGYCEN$4
  IGYCEN$5 IGYCEN$8 IGYCEN$D IGYCEN$R IGYCFGEN IGYCFREE IGYCINIT
  IGYCJA$0 IGYCJA$1 IGYCJA$2 IGYCJA$3 IGYCJA$4 IGYCJA$5 IGYCJA$8
  IGYCJA$D IGYCJA$R IGYCLIBH IGYCLIBO IGYCLIBR IGYCLSTR IGYCLVL0
  IGYCLVL1 IGYCLVL2 IGYCLVL3 IGYCLVL8 IGYCMALL IGYCOB2E IGYCOPI
  IGYCOSCN IGYCPGEN IGYCRCTL IGYCRDPR IGYCRDSC IGYCREAL IGYCRWT
  IGYCSCAN IGYCSIMD IGYCUE$0 IGYCUE$1 IGYCUE$2 IGYCUE$3 IGYCUE$4
  IGYCUE$5 IGYCUE$8 IGYCUE$D IGYCUE$R IGYCXREF IGYDRV   IGYEQCWI
  IGYMSGE  IGYMSGK  IGYMSGT  IGYQCBE  IGYZQDRV IGYZQENU IGYZQJPN
  

Fix information

• Fixed component name

  ENT COBOL FOR Z

• Fixed component ID

  5655EC600

Applicable component levels

• R620 PSY UI70081

     UP20/06/23 P F006

• R621 PSY UI70082

     UP20/06/23 P F006

• R622 PSY UI70083

     UP20/06/23 P F006

• R62H PSY UI70084

     UP20/06/23 P F006

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.