PK91572: ETI801E PGM: ETI VALD STMT: 00054 TYPE: PREPARE DSNT408I SQLCODE20210

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Error message " ETI801E Pgm: ETI VALD Stmt: 00054 Type: PREPARE
  DSNT408I SQLCODE = -20210" would occur if Table Editor was bound
  with an encoding CCSID that is different than the system EBCDIC
  CCSID.. Changes have been made in Table Editor to solve this
  problem.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of DB2 Table Editor.                   *
  ****************************************************************
  * PROBLEM DESCRIPTION: Error message " ETI801E Pgm: ETI VALD   *
  *                      Stmt: 00054 Type: PREPARE DSNT408I      *
  *                      SQLCODE = -20210" would occur if Table  *
  *                      Editor was bound with an encoding CCSID *
  *                      that is different than the system       *
  *                      EBCDIC CCSID. Changes have been made    *
  *                      in Table Editor to solve this problem.  *
  ****************************************************************
  * 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:

  UK49712

Modules/Macros

• ETI$ACES ETI$ADMN ETI$ADM1 ETI$BLOC ETI$BOOT
  ETI$BULD ETI$CAF  ETI$CAFA ETI$COLS ETI$COMM ETI$CONV ETI$DELL
  ETI$DPSC ETI$DPTB ETI$DSQL ETI$EDIT ETI$ESTA ETI$EXPL ETI$FORM
  ETI$INDX ETI$INFO ETI$LOAD ETI$LOB  ETI$LOG  ETI$MAIN ETI$PARS
  ETI$PREX ETI$SAVE ETI$SMSG ETI$SQLC ETI$SQL2 ETI$STGM ETI$UPDT
  ETI$ZPAR ETI#CNVT ETI#JUST ETI#LIKE ETI#OUT  ETI#OUT2 ETI#SQLC
  ETI#SQL2 ETI#STCK ETI#STMT ETI@CAF  ETI@CAFA ETI@CAFW ETI@CNUM
  ETI@COLS ETI@CONN ETI@CSCR ETI@DBC  ETI@DFCK ETI@DSQL ETI@EXP1
  ETI@FIX1 ETI@FORM ETI@IOCT ETI@IOID ETI@IOSC ETI@IOTB ETI@LOB
  ETI@LOGR ETI@ORD1 ETI@PREP ETI@REM1 ETI@RES1 ETI@ROLB ETI@SCCM
  ETI@SCGT ETI@SCIT ETI@SCPT ETI@SCRL ETI@SCR1 ETI@SFND ETI@SIZ1
  ETI@SMSG ETI@SQLD ETI@SRT1 ETI@SSET ETI@SSRT ETI@TCHK ETI@USRT
  ETI@VALD ETI@WDUP ETI@WRIT ETIALLZT ETICAPST ETICHART ETIDAREA
  ETIDYNAL ETIHEXE1 ETIHEXE2 ETIHEXE3 ETIHLI   ETIHLI2  ETILINKL
  ETIMSRT  ETINBLKT ETINNUMT ETINPRNT ETIPRNTT ETISVC26 ETITOKEN
  ETIZPEXT
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R130 PSY UK49712

     UP09/09/10 P F909

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.