PH35070: 4.5 ETIMP MAR 2021

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• This release includes the following improvement:
  1. ILLEGAL SYMBOL "ASCFETCH"
  2. Rewrite Db2 Table Editor EXPORT command
  3. FL509 Exploitation
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of IBM Db2 Table Editor for z/OS       *
  ****************************************************************
  * PROBLEM DESCRIPTION: New V12R1M509 value was added to Db2    *
  *                      APPLCOMPAT bind option in Tools         *
  *                      Customizer.                             *
  *                                                              *
  *                      An error occurred when the Db2 Table    *
  *                      Editor tried to sort any column in the  *
  *                      table with the "Result set limit"       *
  *                      parameter set to "YES".                 *
  *                                                              *
  *                      The "Record length" calculation         *
  *                      algorithm has been changed for          *
  *                      exporting data.                         *
  ****************************************************************
  The support for the function level 509 in the APPLCOMPAT bind
  option for Db2 version 12 was added in the Tools Customizer.
  
  The error "ETI714E - SQL ERROR: ILLEGAL SYMBOL  "ASCFETCH".
  SOME SYMBOLS THAT MIGHT BE e e LEGAL ARE: DESC ASC QUERYNO
  MINUS EXCEPT UNION SKIP"  occurred when Db2 Table Editor tried
  to sort any column in the table with the "Result set limit"
  parameter set to "YES".
  
  The "Record length" calculation algorithm has been changed for
  exporting data.
  

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:

  UI74732

Modules/Macros

• ETI$$PRM ETI2CSVE ETI2DB2  ETI2DCOL ETI2FEXP ETI2MAIN ETI2PCEP
  ETI2PEDT ETI2PFRM ETI2PHST ETI2PLOG ETI2PMAN ETI2PSAC ETI2PSEL
  ETI2PSQL ETI2PTLS
  

Fix information

• Fixed component name

  DB2 TABLE EDITO

• Fixed component ID

  5697G6500

Applicable component levels

• R150 PSY UI74732

     UP21/04/08 P F104

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.