A fix is available
APAR status
Closed as program error.
Error description
This PTF fixes the following issues: 1. When excluding a column with no default value and selecting the table to edit, a message explaining that inserts are not allowed will appear 2. If a valid location name is entered, and then an invalid location name is entered in panel ETI$DPTB, the connection to the valid location is not closed. If an incorrect location name is then changed to a valid location name, the current table listing displayed in panel ETI$DPTB is incorrect 3. Entering an invalid find command on the command line while in browse mode disabled the pf3 and pf4 keys 4. An incorrect edit error could occur on some numeric columns that contain defaults if a row is inserted and subsequently repeated 5. When explicitly entering the name of a remote alias in panel ETI$MAIN, no columns appear in the column selection panel 6. A ABENDS0C4 occurs when entering "zoom" mode on a null varchar, changing the null indicator to "N", and then exiting "zoom" mode 7. Includes various fixes related to entering incorrect SQL in panel ETI$DSQL. Error checking is now performed when the enter key is pressed
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 Table Editor User's * **************************************************************** * PROBLEM DESCRIPTION: 1. When excluding a column with no * * default value and selecting the * * table to edit, a message * * explaining that inserts are not * * allowed will appear * * * * 2. If a valid location name is * * entered, and then an invalid * * location name is entered in panel * * ETI$DPTB, the connection to the * * valid location is not closed. If an * * incorrect location name is then * * changed to a valid location name, * * the current table listing displayed * * in panel ETI$DPTB is incorrect * * * * 3. Entering an invalid find command on * * the command line while in browse * * mode disabled the pf3 and pf4 keys * * * * 4. An incorrect edit error could occur * * on some numeric columns that contain * * defaults if a row is inserted and * * subsequently repeated * * * * 5. When explicitly entering the * * name of a remote alias in panel * * ETI$MAIN, no columns appear in the * * column selection panel * * * * 6. A ABENDS0C4 occurs when entering * * "zoom" mode on a null varchar, * * changing the null indicator to "N", * * and then exiting "zoom" mode * * * * * * 7. Includes various fixes related to * * entering incorrect SQL in panel * * ETI$DSQL. Error checking is now * * performed when the enter key is * * pressed * **************************************************************** * RECOMMENDATION: * **************************************************************** Code changes have been made to correct these problems
Problem conclusion
APPLY PTF
Temporary fix
Comments
APAR Information
APAR number
PQ66885
Reported component name
DB2 TABLE EDITO
Reported component ID
5697G6500
Reported release
130
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2002-10-03
Closed date
2002-10-21
Last modified date
2002-11-03
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
ETI$ADM1 ETI$BLOC ETI$BULD ETI$COLS ETI$COMM ETI$DELL ETI$DPSC ETI$DPTB ETI$DSQL ETI$EDIT ETI$EXPL ETI$FORM ETI$INDX ETI$INST ETI$MAIN ETI$PARS ETI$SORT ETI$STGM ETI$UPDT ETI@CONN ETI@IOCT ETI@IOID ETI@IOSC ETI@IOTB ETI@PREP ETI@TCHK ETI@VALD ETI@WDUP ETI@WRIT ETICHART ETIPRNTT
Fix information
Fixed component name
DB2 TABLE EDITO
Fixed component ID
5697G6500
Applicable component levels
R130 PSY UQ70763
UP02/11/01 P F210
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.
[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0"}]
Document Information
Modified date:
30 March 2021