IBM Support

PH40825: SQL COMPILE ERROR IGYPS0212-S SQL HOST VAR REFERENCE INVALID 49 LEVELS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQL compile error IGYPS0212-S SQL host var reference invalid
    49 levels
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Enterprise COBOL for z/OS V6 who    *
    *                 compile progrms with the SQL compiler        *
    *                 option                                       *
    *                 where host variables have index names        *
    *                 included in a group structure                *
    ****************************************************************
    * PROBLEM DESCRIPTION: Compiler incorrectly flags a group item *
    *                      that contains index names with compile  *
    *                      error IGYPS0212-S SQL host var          *
    *                      reference invalid                       *
    ****************************************************************
    * RECOMMENDATION: Install provided PTF and recompile           *
    ****************************************************************
    The compiler was not properly skipping over index names while
    declaring the subordinate data items to a host variable group
    item, and tried to declare an index name as a host variable.
    

Problem conclusion

  • The compiler was changed to correctly skip over index names that
    are included in a host variable group data item when declaring
    host variables to Db2
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH40825

  • Reported component name

    ENT COBOL FOR Z

  • Reported component ID

    5655EC600

  • Reported release

    630

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-09-22

  • Closed date

    2021-09-27

  • Last modified date

    2021-10-01

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

    PH39617

  • 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 IGYCLIBR IGYCLSTR IGYCLVL0 IGYCLVL1 IGYCLVL2
    IGYCLVL3 IGYCLVL8 IGYCMALL 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  IGYQSPLT IGYSIDE2 IGYZQEN6 IGYZQENU
    IGYZQJP6 IGYZQJPN
    

Fix information

  • Fixed component name

    ENT COBOL FOR Z

  • Fixed component ID

    5655EC600

Applicable component levels

  • R630 PSY UI77327

       UP21/10/01 P F109

  • R631 PSY UI77328

       UP21/10/01 P F109

  • R632 PSY UI77329

       UP21/10/01 P F109

  • R63H PSY UI77330

       UP21/10/01 P F109

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":"630","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
12 December 2023