PK47784: SQLCODE332 CHARACTER CONVERSION BETWEEN CCSID 1200 TO 65534 REQUESTED BY DSNXROHB IS NOT SUPPORTED

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Table Editor tries to UPDATE a TABLE with VARGRAPHIC COLUMNs and
  has MIXED=NO specified in DB2.  DB2 generates the following
   DSNT408I SQLCODE = -332, ERROR:  CHARACTER CONVERSION BETWEEN
   CCSID 1200 TO 65534 REQUESTED BY DSNXROHB IS NOT SUPPORTED
   DSNT418I SQLSTATE   = 57017 SQLSTATE RETURN CODE
   DSNT415I SQLERRP    = DSNXEASC SQL PROCEDURE DETECTING ERROR
   DSNT416I SQLERRD    = -100  0  0  -1  0  0 SQL DIAGNOSTIC
  Table Editor should avoid this error.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Table Editor tries to UPDATE a TABLE    *
  *                      with VARGRAPHIC COLUMNs and has         *
  *                      MIXED=NO specified in DB2.  DB2         *
  *                      generates the following                 *
  *                       DSNT408I SQLCODE = -332, ERROR:        *
  *                       CHARACTER CONVERSION BETWEEN           *
  *                       CCSID 1200 TO 65534 REQUESTED BY       *
  *                       DSNXROHB IS NOT SUPPORTED              *
  *                       DSNT418I SQLSTATE   = 57017            *
  *                       SQLSTATE RETURN CODE                   *
  *                       DSNT415I SQLERRP    = DSNXEASC SQL     *
  *                       PROCEDURE DETECTING ERROR              *
  *                       DSNT416I SQLERRD    = -100  0  0  -1   *
  *                        0  0 SQL DIAGNOSTIC                   *
  *                      Table Editor should avoid this error.   *
  ****************************************************************
  * 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:

  UK27557

Modules/Macros

•    ETI$COLS ETI$UPDT ETI@PREP ETI@WDUP ETI@WRIT
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSY UK27557

     UP07/08/01 P F707

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.