DB2 Table Editor Version 4.3 (Also apply CTC Common Code PTFs)

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: 6 July 2023

APAR	CLOSE DATE	PTF(s)	Fixing APAR if PE	HIPER?	Abstract
DB2 Table Editor Version 4.3 (Also apply CTC Common Code PTFs)
PI04847	12_Dec 2013	UI13485			SQLCODEN311 MAY OCCUR WHEN WORKING WITH TABLE WITH MAX NUMBER COLUMNS ( 749 COLUMNS )
PM74552	2_Nov 2012	UK83216			SCROLL TYPE 'CSR' NOT WORKING ON ZOOM PANEL
PM68888	20_Aug 2012	UK81193			ETI801E PGM: ETI@VALD STMT: 00054 TYPE: PREPARE. ERROR MESSAGE"SQLCODE = -104, ERROR: ILLEGAL SYMBOL ",10" CAN ALSO OCCUR.
PM63677	31_Jul 2012	UK80720			ETI133E ERROR TRYING TO SAVE SQL
PM56732	15_Feb 2012	UK76226			VERIFICATION WARNING WHEN ENTERING A 'S' OR ENTER END*COMMAND TORETURN TO ISPF
PM48934	21_Dec 2011	UK75036			ABEND0C1, S0C4 OR S0C6 MAY OCCUR WHEN EDITING USING HEX COMMAND.
PM51922	30_Nov 2011	UK74377			ABENDS0C4 IN ETI$DSQL
PM33897	11_Jul 2011	UK69622			ENHANCE COMMENTS IN SETISAMP(ETIDB21T) REFERENCING DB2 ADMIN TOOL RELEASE
PM38083	17_Jun 2011	UK68899			SUPPORT FOR DB2 V10 BUSINESS TIME
PM36451	3_Jun 2011	UK68461			INCORRECT ETICLIST ENTRY THAT RESULTS IN DATASET NOT BEING ALLOCATED WITH CORRECT NAME 11/04/12 PTF PECHANGE
PM25671	25_Feb 2011	UK65241	PM36451		INCORRECT ETICIST ENTRY THAT RESULTS IN EXTRA DATASET BEING ALLOCATED UNDER ISPTLIB.
PM21877	8_Feb 2011	UK64653			SQLCODE = -310, ERROR: DECIMAL HOST VARIABLE OR PARAMETER 3 CONTAINS NON-DECIMAL DATA
PM21856	28_Jan 2011	UK64371			MESSAGING ENHANCEMENTS
PM20110	4_Oct 2010	UK61059			ETI ISPF - DB2 V10 EXPLOITATION SUPPORT
PM13338	31_Aug 2010	UK60151			ADD THE ABILITY TO DB2 TABLE EDITOR TO CHOOSE A DEFAULT LOCKING OPTION WHEN DISPLOCK IS SET TO NO
PM11572	21_Jun 2010	UK58136			SQLCODE302 MAY OCCUR WHEN DELETING DUPLICATE ROWS
PM11942	2_Jun 2010	UK57555			ETI130I - THIS TABLE RESIDES ON A SUBSYSTEM WHERE THE TIME FORMAT IS SET TO USA
PM04565	27_May 2010	UK57354			ALLOW MORE CONTROL OVER THE NAMING OF THE DATASETS DURING DB2 TABLE EDITOR CONFIGURATION.
PM11574	18_May 2010	UK57039			SAVED LENGTH OF VARCHAR VALUES LESS THAN INSERTED/UPDATED LENGTH
PM08640	19_Apr 2010	UK56214			DB2 TABLE EDITOR MESSAGE "YOU HAVE CHOSEN OVER 65 CHARACTERS OF FROZEN TABLE SPACE" EVEN THOOUGH TOTAL COLUMN LENGTH UNDER 65
PM04956	23_Mar 2010	UK55494			S0C4 ABEND IN TABLE EDITOR CAN OCCUR WHEN TYPING A VALUE INTO AFIELD THAT IS NULLABLE AND IS SET TO NULL.
PM01993	27_Jan 2010	UK53904			ETI028E INSUFFICIENT STORAGE
PK94813	28_Sep 2009	UK50544			PROVIDE THE ABILITY TO SPECIFY COLUMN NAMES OR LABELS TO BE DISPLAYED IN DB2 TABLE EDITOR
PK91572	31_Aug 2009	UK49712			ETI801E PGM: ETI VALD STMT: 00054 TYPE: PREPARE DSNT408I SQLCODE20210
PK83491	21_May 2009	UK46798			SYSTEM ABEND 0C4 REASON CODE 11 IN ETI$BLOC
PK81263	23_Apr 2009	UK45970			INVALID DATA ENTERED FOR A NUMERIC DATATYPE
PK80582	16_Mar 2009	UK44928			UNSUCCESSFUL BIND FOR PACKAGE = DA10.ETI43X.ETI@LOB.()
PK73576	29_Jan 2009	UK43583			ADD ABILITY FOR ADMINISTRATORS TO PREVENT USERS FROM CHANGING THE LOCKING OPTION, IN DB2 TABLE EDITOR.
PK76230	29_Jan 2009	UK43583		HIPER	ROLLUP SUPPORT INTERNAL CHANGES TO COMMON CODE
PK78035	29_Jan 2009	UK43583		HIPER	ROLLUP APAR
PK73536	29_Jan 2009	UK43583			ENHANCED CAPS ON COMMAND
PK64887	24_Sep 2008	UK40149			INVALID ERROR MESSAGE "INVALID DATA ENTERED FOR A NUMERIC DATATYPE" ON DB2 V9 SYSTEM.
PK61544	3_Jun 2008	UK37033			ROW COUNT COMMAND RESULTS TO INCLUDE TABLE NAME ALONG WITH ROW COUNT
PK59083	25_Mar 2008	UK34935			MESSAGE "INVALID DATA ENTERED FOR A NUMERIC DATATYPE" ON DB2 V9 DATATYPE WITH DEFAULT VALUE DEFINED
PK50138	11_Dec 2007	UK32131			ADDITIONAL FIXES TO SUPPORT DECFLOAT DATA TYPE
PK52243	11_Dec 2007	UK32131			CONTROL FILE NOT BEING FREED ON EXIT
PK52619	11_Dec 2007	UK32131			POSSIBLE LOCK ESCALATION WHEN BROWSING DATA
PK55745	11_Dec 2007	UK32131			SQLCODE151 CAN OCCUR WHEN UPDATING DATA WITH EMBEDDED SPACES
PK44388	25_Oct 2007	UK30641			XML SUPPORT FOR ISPF
PK48982	25_Oct 2007	UK30641			SHARE-LEVEL LOCK NOT RELEASED WHEN THE TABLE IS ACCESSED IN BROWSE MODE THROUGH AN ALIAS
PK47784	27_Jul 2007	UK27557			SQLCODE332 CHARACTER CONVERSION BETWEEN CCSID 1200 TO 65534 REQUESTED BY DSNXROHB IS NOT SUPPORTED
PK38777	29_Jun 2007	UK26714			DSNT408I SQLCODE405 WHEN EDITING DECFLOAT COLUMNS
PK42474	9_May 2007	UK24905			ABEND0C4 RC04 IN ETI$JUST OR ETI$BLOC
PK40581	29_Mar 2007	UK23498			MISSING POSSIBILITY TO EDIT THE GENERATED SQL AND GIM23911E FAILED FOR MODULE ETI$CAFA 07/03/13 PTF PECHANGE
PK35641	13_Feb 2007	UK22100			IEC130I GRISQ DD STATEMENT MISSING OCCURS WHEN EXITING PANEL ETI$DPSC OR ETI$DPS8
PK37553	26_Jan 2007	UK21617			INCORRECT EXPONENT WHEN USING FLOAT DEFINED COLUMN
PK36500	19_Jan 2007	UK21398			ETI046E MESSAGE APPEARS WHEN EDITING A LONG VARCHAR ON TABLE WITH UNIQUE INDEX
PK33112	10_Jan 2007	UK21159	PK40581		DECFLOAT FOR DB2 V9 NOT WORKING USING ZOOM.
PK33802	7_Nov 2006	UK19474			ALLOW OPTION TO DO INSERT WHEN IN FORM MODE
PK32090	11_Oct 2006	UK18716			THIS APAR WILL INTRODUCE SAVE COMMAND FUNCTIONALITY AND WILL INCLUDE HELP INFORMATION.
PK30095	22_Sep 2006	UK18255			DB2 V9 COMPATIBILITY
PK27153	7_Jul 2006	UK16104			USER ABEND 50 CAN OCCUR WHEN ATTEMPTING TO EDIT A TABLE
PK26437	20_Jun 2006	UK15582			ACCESSING COLUMN DEFINITIONS VIA ALIAS RESULTS IN NO DATA FOUND
PK24931	31_May 2006	UK14995			ETI801E ERROR MESSAGE WHILE UPDATING TABLE WITH ROWID
PK24827	25_May 2006	UK14816			ETI132I MESSAGE ON ETI$DPSC CAN OVERLAY ETI082I MESSAGE WHEN USING BROWSE MODE
PK23059	8_May 2006	UK14286			TABLE EDITOR PF KEYS (F4 & F5) NOT GETTING RESET WHEN EXITING PRODUCT.
PK23499	28_Apr 2006	UK14056			SORT OPTIONS MODIFIED AND SORT FAST COMMAND ADDED
PK21020	4_Apr 2006	UK13263			SLOW RESPONSE TIME ON ETI$MAIN PANEL WHEN SELECTING A TABLE FOR EDIT
PK15816	14_Mar 2006	UK12603			MODIFY TO DISPLAY 'BLANKS' FOR LOW VALUES ON ZOOM PANEL (ETI$EXPL).
PK20816	9_Mar 2006	UK12462			ENHANCE EDITS ALLOWED TO ROWS WITH TIME COLUMNS CONTAINING SECONDS WHEN THE SUBSYSTEM DEFAULT IS TIME=USA
PK18559	22_Feb 2006	UK12025			ISPP352 ERROR CAN OCCUR ON HELP PANELS WITH ISPF SESSION PARAMETER 24X80
PK18801	22_Feb 2006	UK12019			ALLOCATION ERROR WHEN USERID NOT USED AS A HIGH LEVEL QUALIFIER ON SQL FILE . AFTER MESSAGE ETI133I
PK18640	20_Feb 2006	UK11920			UNABLE TO INVOKE TABLE EDITOR FROM DB2 ADMIN TOOL AFTER PTF UK10432
PK17677	6_Feb 2006	UK11513			INCOMPLETE BLOCK COMMANDS INCORRECTLY PREVENT PAGING
PK17638	18_Jan 2006	UK10904			SQL MEMBER NOT SAVED AS EXPECTED
PK17475	13_Jan 2006	UK10800			ABEND S0C4-X'11' IN ETI$BUILD AT OFFSET X'7A8'
PK16080	15_Dec 2005	UK10148			SQLCODE100 AND ETI097E
PK16089	14_Dec 2005	UK10080			PERMANENT VIEW IN CSORT HAS DEFAULT SET INCORRECTLY
PK16105	12_Dec 2005	UK09983			PROVIDE AN INDICATOR FOR WHERE CLAUSE UPDATES ON PANELS ETI$DPSCAND ETI$DSQL.
PK15126	6_Dec 2005	UK09821			PDS FOR THE SAVED PROFILE IS OUT OF SEQUENCE WITH THE $INDEX ANDTHE ABILITY TO LOAD SQL FAILS DUE TO ($) SYMBOL.
PK14035	30_Nov 2005	UK09642			SQLCODE -107 OCCURS WHEN ENTERING WHERE CLAUSE CRITERIA ON PANELETI$DSQL FOR A DB2 V8 TABLE (ENFM ONLY)
PK15129	18_Nov 2005	UK09308			LINK-EDIT ERRORS IEW2480W AND IEW2482W (DUE TO EXTRANEOUS "CTC" REFERENCES) CAN OCCUR WHEN APPLYING ETI MAINTENANCE.
PK14353	14_Nov 2005	UK09086		HIPER	ROLL-UP APAR - ISPF
PK12212	5_Oct 2005	UK07863			SPECIFYING "TABLE CREATOR LIKE" VALUE < 8 BYTES WITHOUT WILDCARD CAN ERRONEOUSLY OMIT QUALIFYING TABLES FROM RESULTING LIST
PK11218	16_Sep 2005	UK07330			ERROR OCCURS ALLOCATING .SQL FILE UPON 1ST EXECUTION OF ETICLIST. ALSO, EXTENDED HELP FOR ERROR MSG ETI133E FAILS.
PK08685	6_Sep 2005	UK06967			FIND COMMAND DOESN'T FIND A VALUE IN THE SPECIFIED COLUMN
PK09143	11_Aug 2005	UK06198			NEEDS FUNCTIONALITY TO SAVE SQL FROM DB2 TABLE EDITOR FOR REUSE
PK08659	27_Jul 2005	UK05797			S0C4-4 OR TRUNCATED DATA APPEAR IN ETI$FORM WHEN BROWSING A VIEW
PK08461	26_Jul 2005	UK05740			PERFORMING A SEARCH ON THE FIRST COLUMN, SPECIFING THE COLUMN NAME, RESULTS IN A "INVALID COLUMN NAME OR NUMBER" ERROR.
PK07372	28_Jun 2005	UK04948			INCORRECT BEHAVIOR OF THE FIND COMMAND POSITIONING AND PROPERLY RETURNING NEXT OCCURRENCE.
PK05302	8_Jun 2005	UK04271			WHEN EDITING TABLES CONTAINING A LABEL TYPE COLUMN, THE "FIND" COMMAND DOES NOT WORK WHEN SPECIFYING A COLUMN NAME.
PK06074	8_Jun 2005	UK04271			ABEND S0C4 REASON CODE=00000011, OFFSET=000007B0 MODULE=ETI$BULD
PK03323	5_May 2005	UK03169			COUNT COMMAND ON WHERE CLAUSE CONTAINING MULTIPLE CRITERIA ERRONEOUSLY RETURNS COUNT PERTAINING TO 1ST WHERE CRITERIA ONLY.
PK04410	5_May 2005	UK03169			HELP PANEL NOT FOUND
PK03546	25_Apr 2005	UK02772			ABENDS0C4 BROWSING TABLES WITH 154 COLUMNS
PK04019	25_Apr 2005	UK02772			FIND COMMAND INCORRECTLY RESETS SEARCH POSITION
PK04328	25_Apr 2005	UK02772			FIND COMMAND LOCATES STRING, THEN BLOCK COPY ACTION OCCURS, THENREPEATING THE FIND COMMAND FAILS - SOMETIMES RESULTING IN LOOP
PK03318	22_Apr 2005	UK02733			HOST VARIABLES USED WITH PKG ETI@IOSC HAVE INCORRECT LENGTHS - CAUSING POOR PERFORMANCE WHEN BOUND IN DB2 V7.
PK01327	12_Apr 2005	UK02333			ABENDU0050 AT OFFSET 1FD6 IN LOAD MODULE ETILINKL
PK02066	30_Mar 2005	UK01951			CAPS OFF COMMAND ISN'T FUNCTIONING IN PANEL ETI$EDIT WHEN ENTERED IN LOWERCASE CHARACTERS
PK01222	14_Mar 2005	UK01456			ENTERING INVALID TABLE NAME IN TE GIVES NO "TABLE NOT FOUND" MESSAGE
PQ99669	7_Mar 2005	UK01209			DD "ETICLIST" REMAINS ALLOCATED AFTER EXITING ETICLIST CLIST
PQ99853	21_Feb 2005	UK00777			EDITING A TABLE CAN RESULT IN DATA CORRUPTION TO SPECIAL OR NON-DISPLAY CHARACTERS OF A VARCHAR COLUMN.
PQ99844	4_Feb 2005	UK00306			ETI$MAIN: S0C1 RC01 OCCURS IF TABLE LOCATION FIELD BLANK AND DB2 SSID ENTERED THAT IS UNACCESSIBLE FROM CURRENT LPAR
PQ99217	31_Jan 2005	UK00170			ON PANEL ETI$EDIT, AN INSERT ACTION FOLLOWED BY AN IMMEDIATE UNDO ACTION RESULTS IN ERRONEOUS DISPLAY OF ERROR MSGETI038
PQ98909	10_Jan 2005	UQ96716			ETI801E ERROR MSG AND -130 SQLCODE UPON DELETE ACTION INVOLVING MIXED DATA
PQ96309	21_Dec 2004	UQ96356			INVOKING DB2 TABLE EDITOR FROM DB2 ADMIN. TOOL DOESN'T SUPPORT DB2 V8 LONG TABLE NAMES
PQ98030	21_Dec 2004	UQ96356			ABEND U0050 IN PROGRAM ETILINK AT OFFSET X'1F92' IN ispf BROWSE ON TABLE DEFINED WITH DATE/TIME COLUMNS
PQ97376	2_Dec 2004	UQ95673			INCORRECT GRAPHIC DATA DISPLAYED, FOLLOWED BY AN ABENDS0C4 IN LOAD MODULE ETI$DSQL S0C4
PQ96303	16_Nov 2004	UQ95126			ROLL-UP APAR - SERIES 2
PQ92668	6_Oct 2004	UQ93722			ABEND S913 when user unauthorized for update to Control File access file in setup, ETICLIST corrected
PQ94906	6_Oct 2004	UQ93722			ABEND S0C4 AT X'2FE' IN ETI$COMM IN LOAD MODULE ETI$DSQL CAN OCCUR ON UPDATE OF CHAR(255) COLUMN
PQ90253	13_Sep 2004	UQ92825			DB2 V8 SHOULD CHANGE COLUMN NAMES TO 30 BYTES, NOT 128 BYTES
PQ90468	13_Sep 2004	UQ92825			Entering line command "R" (repeat) on a row of generated SQL a -199 SQL ( SQLCODE199 ) error occurs.
PQ90471	13_Sep 2004	UQ92825			Data corruption occurs when modifying a generated SQL statement by entering DBCS text
PQ92225	13_Sep 2004	UQ92825			ROLL-UP APAR
PQ88895	13_Sep 2004	UQ92825			Change command producing unexpected results when used with DBCS shift characters
PQ83344	30_Jun 2004	UQ90252			DB2 ETI Table Editor ZOOM command conflicts with client-developed ISPF ZOOM command
PQ88394	9_Jun 2004	UQ89435			Roll-up APAR
PQ83761	3_Jun 2004	UQ89221			SQLCODE130 OCCURS WHEN EDITING ON A MIXED CHARACTER TYPE THAT IS>255 BYTES IN LENGTH.
PQ83765	3_Jun 2004	UQ89221			INTRODUCE SUPPORT FOR DBCS COLUMN NAMES AND DATA
PQ85792	27_Apr 2004	UQ87123			ABEND0C4 OR ABENDS878 RC10 IN TABLE EDITOR WHEN USING COPY COMMAND IN EDIT TABLE MODE.
PQ87026	27_Apr 2004	UQ87863			Rows are being flagged incorrectly as updated when edits are made in zoom mode to hex data.
PQ87290	27_Apr 2004	UQ87863			NOT FOUND OCCURS ON TABLE NAME LIKE FIELD WHEN TABLE NAME ENTERED CONTAINS 18 CHARACTERS OR 17 CHARACTERS PLUS WILD CARD *
PQ85945	27_Apr 2004	UQ87123			WHEN ENTERING A TABLE IN BROWSE OR EDIT A COLUMN THAT CONTAINS A "0" ONLY WILL BE CENTERED AND SHOULD BE RIGHT JUSTIFIED.
PQ87635	27_Apr 2004	UQ87863			SQLCODE104 RESULTS ON PANEL ETI$DPSC WHEN ENTERING THE COUNT COMMAND USING A COMPOUND WHERE CLAUSE.
PQ87657	27_Apr 2004	UQ87863			DATA CORRUPTION CAN OCCUR WHEN SHOW SEPARATOR = "Y" FOR DECIMAL,SMALLINT OR INTEGER DEFINED COLUMNS
PQ86145	7_Apr 2004	UQ87123			AbendS878 RC10 (abend S878 RC 10) when trying to edit or browse a large table.
PQ82654	30_Mar 2004	UQ86367			Left-most column affected by MAX CHAR DISPLAY value can erroneously be un-editable (read only).
PQ86614	30_Mar 2004	UQ86367			AE PQ80771
PQ80771	18_Mar 2004	UQ86367			ADD SUPPORT FOR DB2 VERSION 8
PQ81474	22_Dec 2003	UQ83493			Residual data in INSERT after failure of a previous INSERT, large row size + large max chars abends0c4 in CTC$SCR1.
PQ75208	30_Jul 2003	UQ79029			ZOOM MODE SHOWS INCORRECT LENGTH VALUE IN EDIT MODE WHEN DISPLAYING A VARCHAR GREATER THAN 72 BYTES IN LENGTH.
PQ75727	18_Jul 2003	UQ78715			S0C4 abend occurs when selecting a view from panel ETI$DPTB, then returning to search for another fully-qualified table name.
PQ74628	30_Jun 2003	UQ78159			This APAR adds the ++CALLLIBS statement that was omitted from PTF UQ68695.
PQ71853	21_Mar 2003	UQ75274			VARIOUS ABENDS WHEN SORTING IN DESCENDING ORDER AFTER INSERTING A ROW
PQ71847	17_Mar 2003	UQ75133			MATCH NOT FOUND WHEN PERFORMING A REPEAT FIND, AFTER A MATCH WASFOUND IN TRUNCATED DATA
PQ70953	3_Mar 2003	UQ74666			ABENDS0C4 OCCURS WHEN USING FORM MODE: CHANGES MADE TO HELP PANELS: SPEED IMPROVEMENTS WHEN EXITING A TABLE CONTAINING FLOAT
PQ70419	14_Feb 2003	UQ74143			SQLCODE107 OCCURS WHEN ATTEMPTING TO INSERT SQL: UNDERSCORE CHARACTERS REMOVED FROM DATA FIELDS
PQ70091	30_Jan 2003	UQ73688			ABENDS0C4 ENCOUNTERED WHEN USING FORM MODE ON SOME TABLES IN TE ISPF V430
PQ69622	17_Jan 2003	UQ73383			MSGETI095 MSGETI097 DURING UPDATE OR DELETE THE LAST ROW IN A TABLE WHILE HAVING THE COMMIT SCOPE GREATER THAN NUMBER OF ROWS
PQ69082	8_Jan 2003	UQ73061			ABEND WHEN SORTING DATE COLUMN:SQLCODE104 OCCURS WHEN UPDATING &DELETING DUPLICATE ROWS: SOME DATA MAY NOT COMMIT IN FORM MODE
PQ68314	16_Dec 2002	UQ72664			SQLCODE010, ABENDS0C4 OR SQLCODE199 WHEN ISSUING WHERE CLAUSE ON TABLE WITH EXCLUDED COLUMNS: WHERE CLAUSE EXTENSION
PQ67235	12_Nov 2002	UQ71688			CHANGE COMMAND USED IN TRUNCATED DATA: NON-DISPLAYABLE CHARACTERS DISPLAYED: ERROR MESSAGE ADDED: HELP PANEL ADDITIONS
PQ66885	21_Oct 2002	UQ70763			ABEND0C4 WHEN EXITING ZOOM MODE: ADDED MESSAGE WHEN EXCLUDING COLUMNS: PROBLEMS WHEN ENTERING SQL IN THE SQL PANEL.
PQ66560	11_Oct 2002	UQ70763			ABENDS0C4 WHEN ENTERING FORM ON SOME TABLES: ABEND0C4 WHEN DELETING LINE: ERROR MESSAGES NOT CALLED IN SOME INSTANCES
PQ63870	4_Oct 2002	UQ70536			ERRORS WITH CHANGE COMMAND: CHANGES TEXT MESSAGE WITH INCOMPLETEBLOCK COMMANDS: ERRORS WITH NUMERIC SEPARATOR IN DECIMAL FIELDS
PQ63556	18_Sep 2002	UQ69936			PROBLEM INVOKING TABLE EDITOR THROUGH DB2 ADMIN WHEN LOCATION NAMES ARE USED: ALLOWS SSID FROM DB2 LAUNCHPAD VERSION 4.1
PQ62805	2_Aug 2002	UQ68695			FLOAT PRECISIONS ARE NOT DISPLAYED, SQLCODE104 ON COUNT COMMAND ALLOWANCE FOR SPECIAL CHARACTERS.

Top of page