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

Obtain the fix for this APAR.

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 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.