A fix is available
APAR status
Closed as program error.
Error description
Unexpected SQLCODE413 could happen for an SQL statement containing a predicate with a DOUBLE or FLOAT column and a string that represents a number in scientific notation.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All DB2 10 and 11 for z/OS users of an SQL * * statement containing a predicate with a * * DOUBLE or FLOAT column and a string that * * represents a number in scientific notation. * **************************************************************** * PROBLEM DESCRIPTION: Unexpected SQLCODE413 could happen for * * an SQL statement that satisfies all of * * the following conditions: * * * * 1. It contains a subquery, references * * a view or it is an UPDATE or DELETE * * statement. * * 2. It contains a predicate with a * * column and a string that represents * * a number in scientific notation. * * 3. The data type of column is DOUBLE or * * FLOAT. * **************************************************************** * RECOMMENDATION: * **************************************************************** An example is shown below: CREATE TABLE T1 (C1 DOUBLE); INSERT INTO T1 VALUES (1.2); DELETE FROM T1 WHERE C1 < '2.8E381'; DB2 did not process the aforementioned SQL statement correctly, and this caused the unexpected SQLCODE413.
Problem conclusion
DB2 has been modified to correctly process the aforementioned SQL statement, so there will be no SQLCODE413. Additional keywords: SQLFLOAT SQLDECIMAL SQLDELETE SQLUPDATE SQLSUBQUERY
Temporary fix
Comments
APAR Information
APAR number
PI38994
Reported component name
DB2 OS/390 & Z/
Reported component ID
5740XYR00
Reported release
A10
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-04-15
Closed date
2015-06-07
Last modified date
2015-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
UI28288 UI28289
Modules/Macros
DSNXOPRU
Fix information
Fixed component name
DB2 OS/390 & Z/
Fixed component ID
5740XYR00
Applicable component levels
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSEPEK","label":"Db2 for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"10.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
01 July 2015