A fix is available
APAR status
Closed as program error.
Error description
ETI V4.4 - TCz Installation - The DB2 binds are getting sqlcode=-4700 on certain packages. -4700 ATTEMPT TO USE NEW FUNCTION BEFORE NEW FUNCTION MODE The bind skeleton is ETI#BIND. There is selection logic that controls what bind package statements are generated, based on DB2 level and mode. The selection logic is not correct for certain packages. They should only be generated in NFM. ADDITIONAL SYMPTOMS SQLCODE805 ETI801E Pgm: ETI@IOSC DSNT408I SQLCODE = -805, ERROR: DSNT418I SQLSTATE = 51002 SQLSTATE RETURN
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of DB2 Table Editor. * **************************************************************** * PROBLEM DESCRIPTION: ETI V4.4 - TCz Installation - The DB2 * * binds are getting sqlcode=-4700 on * * certain packages. * * * * -4700 ATTEMPT TO USE NEW FUNCTION * * BEFORE NEW FUNCTION MODE * * * * The bind skeleton is ETI#BIND. There * * is selection logic that controls what * * bind package statements are generated, * * based on DB2 level and mode. The * * selection logic is not correct for * * certain packages. They should only be * * generated in NFM. * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** Code has been changed to correct this condition.
Problem conclusion
APPLY the PTF.
Temporary fix
Comments
APAR Information
APAR number
PM98577
Reported component name
DB2 TABLE EDITO
Reported component ID
5697G6500
Reported release
140
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2013-10-07
Closed date
2013-11-07
Last modified date
2014-03-04
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI12288
Modules/Macros
ETI#BIND
Fix information
Fixed component name
DB2 TABLE EDITO
Fixed component ID
5697G6500
Applicable component levels
R140 PSY UI12288
UP13/11/15 P F311
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.
[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSCVQU2","label":"Db2 Table Editor"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.4.0","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
04 March 2014