IBM Support

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

A fix is available

Subscribe

You can track all active APARs for this component.

 

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.x 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 V5.x or      *
    *                      COBOL V6.x compiler, the generated      *
    *                      SQLCA contains lowercase characters     *
    *                      which could cause quality checks for    *
    *                      the usage of only uppercase 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 uppercase characters
    
     05 SQLERRD PIC S9(9) COMP-5
     OCCURS 6 TIMES.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH08332

  • Reported component name

    ENT COBOL FOR Z

  • Reported component ID

    5655EC600

  • Reported release

    610

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-02-08

  • Closed date

    2019-02-20

  • Last modified date

    2022-06-10

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

    PH07506

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

Modules/Macros

  • IGY8RWTU IGYCCBE  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 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

  • R610 PSY UI61391

       UP19/02/23 P F902

  • R611 PSY UI61392

       UP19/02/26 P F902

  • R612 PSY UI61393

       UP19/02/26 P F902

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.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SS6SG3","label":"Enterprise COBOL for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"6.1","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
12 December 2023