DB2 - Problem description
Problem IT31185 | Status: Closed |
SQL0401N OR SQL0901N ERROR RETURNED WHEN QUERY CONTAINS TIMESTAMP FUNCTIONS IN WHEN CLAUSE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
Under rare conditions, DB2 may return an SQL0401N or SQL0901N error when a query contains a TIMESTAMP function in the branches of a WHEN clause. Example query snippet: (CASE WHEN TEST.BEG_DT > date('12/31/2015') THEN TIMESTAMP (TEST.BEG_DT, '00.00.00') ELSE TIMESTAMP('12/31/2015') END) AND (CASE WHEN TEST.END_DT < date('04/01/2015') THEN TIMESTAMP (TEST.END_DT, '23.59.59') | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * db2 luw * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
**************************************************************** * USERS AFFECTED: * * db2 luw * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 10.5 Fix Pack 7. * **************************************************************** | |
Comment | |
First fixed in DB2 Version 10.5 Fix Pack 7. | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 06.12.2019 23.02.2020 23.02.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |