PH09478: The SQL (Db2) coprocessor emits a definition of SQLCA item SQLERRD containing lower case characters

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Although the rest of the SQLCA is generated in uppercase in
  response to an EXEC SQL INCLUDE SQLCA statement, the SQLERRD
  definition contains some lowercase characters:
  
      05 SQLERRD PIC s9(9) comp-5
                 OCCURS 6 TIMES.
  
  This has no effect on program function as the compiler is case
  insensitive (for other than literals).
  
  It may however affect programs reading the processed text from
  SYSMDECK or using the PRTEXIT.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of the V5.x and V6.2 Enterprise COBOL  *
  *                 Compiler who are also using the integrated   *
  *                 Db2 coprocessor (SQL compiler option).       *
  ****************************************************************
  * PROBLEM DESCRIPTION: Incorrect output: When using the Db2    *
  *                      Coprocessor with the                    *
  *                      COBOL V6.2 compiler, the generated      *
  *                      SQLCA contains lower case characters    *
  *                      which could cause quality checks for    *
  *                      the usage of only upper case characters *
  *                      for all COBOL-syntax in the MDECK file  *
  *                      to fail.                                *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  The data item SQLERRD in the Enterprise COBOL compiler is
  defined as follows:
  
   05 SQLERRD PIC s9(9) comp-5
   OCCURS 6 TIMES.
  

Problem conclusion

• The data item definition for SQLERRD has been updated in the
  compiler, so that it only contains upper case characters
  
   05 SQLERRD PIC S9(9) COMP-5
   OCCURS 6 TIMES.
  

Temporary fix

Comments

APAR Information

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

  PH07506

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

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 IGYCOB2  IGYCOB2E
  IGYCOPI  IGYCOPT  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 UI62019

     UP19/03/29 P F903

• R621 PSY UI62020

     UP19/03/29 P F903

• R622 PSY UI62021

     UP19/03/29 P F903

• R62H PSY UI62022

     UP19/03/29 P F903

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.