PK77586: BIND FAILURES FOR CCSID = 1145 AND 022 BECAUSE THE CIRCUMFLEX ACCENT IN CSSID 032 APPEARS AS A "CENT" CHARACTER.

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• The statement in 'DSN810.xxxx.SCKZDBRM(CKZ00627)'
  
     WHERE TYPE ^= 'A' AND TYPE ^= 'G'
  
  will return an error in the bind process.
  
  This error occurs because the circumflex character
  '^' appears as a 'cents' character in CCSID 1145
  (spanish euro) or 282 (portuguese).
  
  This problem may not be limited to Spanish euro and Portugese
  but may occur in other CSSIDs as well.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: DB2 Cloning Tool.                            *
  ****************************************************************
  * PROBLEM DESCRIPTION: The statement in                        *
  *                      'DSN810.xxxx.SCKZDBRM(CKZ00627)'        *
  *                         WHERE TYPE  = 'A' AND TYPE  = 'G'    *
  *                      will return an error in the bind        *
  *                      process. This error occurs because the  *
  *                      circumflex character ' ' appears as a   *
  *                      'cents' character in CCSID 1145         *
  *                      (spanish euro) or 282 (portuguese).     *
  *                      This problem may not be limited to      *
  *                      Spanish euro and Portugese              *
  *                      but may occur in other CSSIDs as well.  *
  ****************************************************************
  * RECOMMENDATION: APPLY the PTF.                               *
  ****************************************************************
  Code has been changed to correct this condition.
  

Problem conclusion

• APPLY the PTF.
  

Temporary fix

Comments

APAR Information

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

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

  UK44873

Modules/Macros

•    CKZ00624 CKZ00625 CKZ00626 CKZ00627 CKZ00628
  CKZ00629 CKZ00630 CKZ00631 CKZ00632 CKZ00650 CKZ00651 CKZ00652
  CKZ00653 CKZ00654 CKZ00655 CKZ00727 CKZ00728 CKZ00729 CKZ00730
  CKZ00731 CKZ00732 CKZ00752 CKZ00753 CKZ00754 CKZ00755
  

Fix information

• Fixed component name

  DB2 CLONING TOO

• Fixed component ID

  5655N1000

Applicable component levels

• R210 PSY UK44873

     UP09/03/14 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.