Click on an APAR number to display the full information for that APAR. There may be a few days delay after the APAR closes before it is available on this website.
Click on a PTF number to download that PTF. You will need an IBMID. Latest update: 21 November 2024
DB2 Table Editor Version Version 4.5
APAR CLOSE
DATE
PTF(s) Fixing APAR
if PE
HIPER? Abstract
PH63958
5_Nov
2024
UI98963


ADD SUPPORT FOR DB2 V13 FUNCTION LEVEL 506
PH62989
14_Oct
2024
UI98741


ALLOW DB2 TABLE EDITOR TO DO A MASS CHANGE OF NULLS AND FOR A SPECIFIC COLUMN.
PH60899
29_Apr
2024
UI96718


ADD SUPPORT DB2 13 FUNCTION LEVEL 505.
PH57353
3_Nov
2023
UI94262


ADD SUPPORT DB2 13 FUNCTION LEVEL 504
PH55685
17_Aug
2023
UI93230


PERFORMANCE IMPROVEMENTS FOR EDIT AND BROWSE
PH54327
28_Jun
2023
UI92519


TABLE EDITOR DOES NOT SHOW SQLCODE = -514 BUT DOES CAUSE THIS ERROR
PH53763
2_May
2023
UI91660


ADD SUPPORT DB2 13 FUNCTION LEVEL 503.
PH50748
4_Jan
2023
UI83908


DB2 TABLE EDITOR - 4.5 DECEMBER PTF
PH46607
21_Jul
2022
UI81625
UI92519


OPENING VIEW BASED ON MORE THAN ONE TABLE MIGHT RESULT IN ETI714E AND SQLCODE -171.
PH45716
30_Jun
2022
UI81261


SUPPORT FOR DB2 VERSION V13
PH42509
10_Jan
2022
UI78857


DB2 TABLE EDITOR - 4.5 DEC PTF
PH41291
25_Nov
2021
UI78262


ADDED NEW FUNCTION 'IMPORT' ON ETI$EDIT PANEL.
PH40470
4_Oct
2021
UI77414


DB2 TABLE EDITOR - 4.5 AUG PTF
PH38761
3_Aug
2021
UI76565


ROW ORDER ERROR MESSAGE POINTS TO A WRONG ROW, AOT TABLE UPDATEDUSING LOCATION NOT CORRESPONDING TO 'DB2 SSID' SQL ERROR
-4742
PH37459
5_Jul
2021
UI76198


ADD SUPPORT DB2 12 FUNCTION LEVEL 509 AND FUNCTION LEVEL 510. EXTEND WORK WITH AOT TABLES USING THE CLIST.
PH36988
5_Jul
2021
UI76198


EXTEND SIZE OF THE COLUMN "ROW COUNT" IN PANEL "TABLE SELECTION"
PH36250
11_May
2021
UI75336


DB2 TABLE EDITOR - 4.5 APR PTF
PH35070
2_Apr
2021
UI74732


4.5 ETIMP MAR 2021
PH33779
24_Feb
2021
UI74131


4.5 ETIMP FEB 2021
PH32671
11_Jan
2021
UI73415
UI74732


DB2 TABLE EDITOR - 4.5 DECEMBER PTF
PH31602
8_Dec
2020
UI72990
UI74732


DB2 TABLE EDITOR - 4.5 NOVEMBER PTF
PH30215
5_Nov
2020
UI72405
UI74732


VARIOUS IMPROVEMENTS
PH28565
30_Sep
2020
UI71846


DB2 TABLE EDITOR - 4.5 AUGUST PTF
PH27286
14_Aug
2020
UI71074


DB2 TABLE EDITOR - 4.5 JULY PTF
PH27082
6_Jul
2020
UI70352


INVOKE DB2 TABLE EDITOR DIRECTLY AND FETCH ROWS WITHOUT INTERIM PANEL
PH25387
6_Jul
2020
UI70352


ADD NEW PARAMETER ACNAME TO CLIST TO PASS ACCELERATOR NAME TO TABLE EDITOR
PH25330
10_Jun
2020
UI69957
UI70352


'ETI714E - SQL ERROR: CHARACTER CONVERSION BETWEEN CCSID 1200 TO65534' OCCURS DURING OPENING A TBL W/GRAPHIC OR VARGRAPHIC
COLS
PH24119
6_May
2020
UI69374
UI70352


DB2 TABLE EDITOR - 4.5 APRIL PTF
PH22931
31_Mar
2020
UI68710
UI70352


DB2 TABLE EDITOR - 4.5 MARCH PTF
PH21791
28_Feb
2020
UI68141


DB2 TABLE EDITOR - 4.5 FEB PTF
PH20683
29_Jan
2020
UI67629
UI70352


DB2 TABLE EDITOR - 4.5 JAN PTF
PH19825
29_Dec
2019
UI67187


ETIMP 4.5 - DECEMBER 2019 PTF
PH18769
21_Nov
2019
UI66565
UI70352


FIX REPEAT LINE CMD IN ETI$DSQL PANEL: MAKE COPY CMD AVAILABLE IN CMD COLUMN - NOVEMBER 2019 PTF
PH16659
28_Oct
2019
UI66095
UI70352


TABLE CONTAINS < 5000 LINES, RECORD SEARCH RESPONSE IS POOR WHENSETTING "CLOSE CURSOR MODE.... YES" (RESPONSE - PERFORMANCE)
PH16627
27_Sep
2019
UI65562


FIXED PROBLEMS W/EXPORT TO UNIX FILES. ADDRESSED THE INABILITY TO UPDATE TABLE VALUES AFTER RESIZING NULL INDICATOR ('N')
COL
PH15580
28_Aug
2019
UI65008
UI66095
UI70352


USER DOES NOT HAVE THE REQUIRED AUTHORITY TABLE EDITOR WILL ISSUE APPROPRIATE ERROR MESSAGE BUT CONTINUE PROCESSING
PH14578
16_Aug
2019
UI64801


SUPPORT THE ABILITY INCLUDE "TABLE LABEL" COLUMN TO THE ETI$DPTBPANEL - JULY 2019 PTF
PH13594
9_Jul
2019
UI64120
UI64801


IMPROVED PERFORMANCE FOR AUTOMATED ALLOCATION DATA SET EXPORT IMPROVED ACCURACY OF GENERATED ALWAYS VALUES OF COPY/REPEAT
CMDS
PH12323
4_Jun
2019
UI63416


TABLESPACES NOW CREATED AS UNIVERSAL TABLE SPACES (UTS): BETTER 'ORDER BY' CLAUSE CHECKS BEFORE OPENING A QUERY IN EDIT MODE.
PH07222
26_Apr
2019
UI62727
UI63416


TO AVOID PROBLEMS WITH AMBIGUOUS CURSOR USAGE, ENHANCE CURSOR DECLARATION WITH FOR READ ONLY AND FOR UPDATE OF CLAUSES
PH10803
26_Apr
2019
UI62727
UI63416


SQL ERROR -798 APPEARS WHILE INSERTING A ROW INTO A TABLE WITH ACOLUMN DEFINED AS GENERATED ALWAYS.
PH09286
29_Mar
2019
UI62233
UI62727
UI63416


IMPROVED STABILITY FOR REPEATED ROWS IN COLUMN VIEW. (-407 WHEN ROW WAS REPEATED IN A VIEW)
PH08608
25_Feb
2019
UI61484


NEW CONFIGURATION PARAMETER TO RESET CONFIRMATION PROMPTS AFTER SAVE DATA PROMPTS HAVE BEEN TURNED OFF
PH08648
17_Feb
2019
UI61347
UI61484


UPDATE ONLY THOSE CELLS WHOSE VALUES HAVE CHANGED 19/02/15 PTF
PECHANGE
PH06309
8_Feb
2019
UI61218
UI61484
PH08648

UPDATE ONLY THOSE CELLS WHOSE VALUES HAVE CHANGED
PH06342
23_Dec
2018
UI60428


DB2 TABLE EDITOR - PH0XXXX
PH04527
28_Nov
2018
UI59980


LOWER CASE CHAR NOT ALLOWED ON THE PANEL GENERATED SELECT STATEMENT (ETI$DSQL)
PH03366
31_Oct
2018
UI59451


SAVE COLUMN SORT ORDER IN CSORT PANEL ACROSS DB2 TABLE EDITOR EDIT SESSIONS
PH03434
31_Oct
2018
UI59451


UNFIXED COMMAND AFFECTS ON PERMANENTLY FIXED COLUMNS
PH03371
31_Oct
2018
UI59451


IMPROVED PROCESSING TIME WHEN EXPORTING LARGE TABLES
PH01989
21_Sep
2018
UI58659


ENHANCEMENT TO ALLOW USERS TO SELECT DATA FROM A SPECIFIC ACCELERATOR
PH01973
21_Sep
2018
UI58659


BUG FIX FOR RESET VIEW COMMAND ON CFIX, CSORT AND CORDER PANELS
PH01990
21_Sep
2018
UI58659


ENHANCEMENT TO ALLOW USERS TO VIEW TABLES ON A SPECIFIC ACCELERATOR
PH01082
8_Aug
2018
UI57751


VARIOUS FIXES
PI99531
27_Jun
2018
UI56904


OPTIMIZE THE ABILITY TO LOAD MORE TABLES ON THE ETI$DPTB PANEL WITHOUT INCREASING THE REGION SIZE
PI97576
11_Jun
2018
UI56444


NEW OPTION TO GLOBALLY DEFINE THE SKIP LOCKED DATA PARAMETER. SAMPLIB LIBRARY NOW HAS THE CLOSE CURSOR AND ENCODING
PARAMETERS
PI96923
18_May
2018
UI55945


LOGGING IS NOT AVAILABLE WHEN USING TABLE EDITOR STARTED VIA DB2ADMIN
PI96925
18_May
2018
UI55945


ETI$DPTB AND ETI$LOG PANELS DISPLAY INCORRECT VALUE FOR NUMBER OF ROWS
PI95239
13_Apr
2018
UI55237


INCORRECT AND UNEXPECTED UPDATES TO THE COLUMN DEFINED AS VARCHAR
PI96174
13_Apr
2018
UI55237


VARCHAR HEX VALUE IS INCORRECTLY UPDATED AFTER VARCHAR VALUE UPDATED
PI95539
27_Mar
2018
UI54777


WHEN EXITING, PARAMETER TO SET DISPLAY OFF FOR CHANGE CONFIRMATION PANEL (ETI$CSCH) WILL NOW BE SAVED.
PI94087
19_Mar
2018
UI54586


IT IS IMPOSSIBLE TO CANCEL THE UPDATE WHEN THE USER PRESSES F3 ON THE ETI$EDIIT PANEL.
PI93737
28_Feb
2018
UI54135


INCORRECT UPDATES THE COLUMN DEFINED AS CHAR THAT PERMIT NULL VALUE
PI92524
12_Feb
2018
UI53814


SQLCODE -151 NON-UPDATABLE COLUMNS
PI92872
12_Feb
2018
UI53814


SAVED CHANGES WITH CSET COMMAND IN ETI$DPSC PANEL
PI92561
12_Feb
2018
UI53814


INCORRECT EXPORT OF DATA WITH NON-DISPLAYED CHARACTERS
PI91903
30_Jan
2018
UI53557


WHEN UPDATING A VALUE ON A VARCHAR COLUMN FOR A ROW SOME OTHER CHARACTERS ON THAT VARCHAR COLUMN ARE ALSO CHANGED
UNEXPECTEDLY
PI91902
30_Jan
2018
UI53557


INCORRECT RESULTS WHEN UPDATING AN INDEX-PARTITIONED TABLESPACE / ABEND A03000 HEX OCCURRED PROCESSING COMMAND 'ETI2MAIN'
PI91922
15_Jan
2018
UI53218


SQL ERROR -612 APPEARS AFTER EXECUTING QUERY JOIN FROM ETI$DSQL PANEL
PI90788
13_Dec
2017
UI52690


ABEND U4038 SIGABRT FUNCTION SETTING SYMBOLS IN LOCK TABLE UNWANTED WILDCARDS '*' APPEAR ON PANEL ETI$MAIN
PI89069
7_Nov
2017
UI51730


ADD DEFAULT VALUE FOR "CLOSE CURSOR MODE"" AND "DELETES EVERYTHING TO RIGHT OF THE VALUE X'00'
PI88770
24_Oct
2017
UI51382


( RFE 110785 ) NEW PRIMARY COMMAND TO ACCESS USER SETTINGS
PI86699
10_Oct
2017
UI50994


UNNECESSARY CHECKS FOR DSNHLI2 AND DSNWLI2 MEMBERS RESULT IN MSG ETI516E; ADD ABILITY TO HIDE/LIMIT COMMANDS MENU
PI81781
29_Sep
2017
UI50767


PREV/NEXTROW PROVIDED AT FORM PANEL ON PF22/PF23 KEYS, AND FIX SQL DIFFERENCE BETWEEN WHEN COUNT AND DISPLAYING ROW RECORDS.
PI83824
10_Aug
2017
UI49463


1) ISSUE WHEN SCROLLING BY CSR 2) ALLOW USER TO LIMIT RESULT SET - ETI714, ETI714E, 00C90096(00000302)
PI83819
20_Jul
2017
UI48979


FIX FOR FETCH FIRST N ROWS CLAUSE CAN NOT BE USED WITH ORDER BY CLAUSE
PI82512
19_Jun
2017
UI48145


MAX PF11
PI80382
11_May
2017
UI47179


ADD ABILITY TO SPECIFY FORM IN BROWSE MODE
PI78255
13_Apr
2017
UI46405


PROVIDE ADDITIONAL USER OPTION THAT ALLOWS CLOSE CURSOR AFTER EACH OPERATION WITH THE TABLE
PI75357
30_Mar
2017
UI46032


GENERATED ALWAYS COLUMN UPDATED TO NEXT VALUE WHEN UPDATED
PI75360
30_Mar
2017
UI46032


ON UPDATE ROWS COUNT PANEL PF12 KEY WAS CONFUSING SHOWING TWO DIFFERENT USES. REMOVING PF12 KEY FROM PANEL
PI75363
14_Mar
2017
UI45540


ADD SUPPORT FOR ACCELERATOR ONLY TABLES AND NON-SCROLLABLE CURSOR IMPLEMENTATION FOR COMPATIBILITY WITH PREVIOUS VERSION
PI67995
15_Nov
2016
UI42646


EXPORT TABLE EDITOR LOG IN A FILE - ADD COMMAND TO THE LOG PANELSO A USER DOESN'T NEED TO OPEN IT SEPARATELY FOR EXPORT
PURPOSES
PI70010
31_Oct
2016
UI42190


ETI714E: SQLCODE -420 EDITING FIELD DEFINED AS DECIMAL
PI68394
13_Oct
2016
UI41646


ETI120 MESSAGE NOT FOUND IN 'ISPMLIB' LIBRARY
PI67022
12_Sep
2016
UI40772


ETI V4.5 ADD ABILITY TO SPECIFY CAPS ON/OFF AND HEX ON/OFF
PI63039
17_Aug
2016
UI40171


MULTIPLE FIXES FOR ETI V4.5 CODE

Top of page