PI99035: MESSAGE IGYPS0212-S WHEN USING DB2 COPROCESSOR

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Message IGYPS0212-S, indicating an SQL host variable reference
  had invalid syntax or the referenced host variable was an
  invalid SQL variable type, is issued when using DB2
  coprocessor. The message is not issued when using preprocessor.
  

Local fix

• Use preprocessor
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of Enterprise COBOL V5.2 compiling     *
  *                 with the SQL compiler option programs that   *
  *                 contain a DB2 SQL VARCHAR host variable      *
  *                 where the VARCHAR structure has data items   *
  *                 defined with level number 88                 *
  *                 (condition-names) and the VARCHAR host       *
  *                 variable is used in an EXEC SQL statement.   *
  *                 The structure is accepted by the separate    *
  *                 DB2 precompiler.                             *
  ****************************************************************
  * PROBLEM DESCRIPTION: The compiler does not accept            *
  *                      condition-names in VARCHAR host         *
  *                      variables and issues message            *
  *                      IGYPS0212-S.                            *
  *                      If a VARCHAR host variable has in its   *
  *                      structure level 88 condition names,     *
  *                      then the structure is not recognized    *
  *                      as a VARCHAR host variable. For         *
  *                      example:                                *
  *                      01 CHRVAR.                              *
  *                        49 CHRVAR-LENGTH PIC S9(4).           *
  *                           88 CN1 VALUE 5.                    *
  *                           88 CN2 VALUE 10.                   *
  *                        49 CHRVAR-STRING PIC X(10).           *
  *                           88 CN3 VALUE SPACE.                *
  *                                                              *
  *                      In this example, if CHRVAR is           *
  *                      referenced as a host variable in an     *
  *                      EXEC SQL statement then it will not be  *
  *                      recognized as a VARCHAR SQL data type.  *
  *                                                              *
  *                      Example:  If the following SQL          *
  *                      statement was used with the above       *
  *                      data                                    *
  *                      EXEC SQL                                *
  *                         INSERT INTO SAMP.TABLE               *
  *                             (CHARDATA)                       *
  *                             VALUES( :CHRVAR)                 *
  *                      END-EXEC                                *
  *                                                              *
  *                      then the compiler would issue the       *
  *                      following diagnostic message from DB2:  *
  *                                                              *
  *                      IGYPS0212-S SQL host variable           *
  *                      reference "CHRVAR-LENGTH" had           *
  *                      invalid syntax or the referenced        *
  *                      host variable was an invalid SQL        *
  *                      variable type.  The statement was       *
  *                      discarded.                              *
  ****************************************************************
  * RECOMMENDATION: Apply the provided PTF.                      *
  ****************************************************************
  If a VARCHAR host variable has in its structure level number 88
  condition names, the compiler does not recognize the structure
  as a VARCHAR host variable.
  

Problem conclusion

• The compiler is modified to recognize the VARCHAR host variable
  even if it has in its structure level number 88 condition
  names. This makes it compatible with this undocumented
  extension to the separate DB2precompiler.
  

Temporary fix

Comments

APAR Information

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

  PI80688

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

Modules/Macros

• IGY8RWTU IGYCBE   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 IGYECWI  IGYMSGE  IGYMSGK  IGYMSGT
  

Fix information

• Fixed component name

  ENT COBOL FOR Z

• Fixed component ID

  5655W3200

Applicable component levels

• R520 PSY UI56404

     UP18/06/21 P F806

• R521 PSY UI56405

     UP18/06/22 P F806

• R522 PSY UI56406

     UP18/06/22 P F806

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.