DB2 FOR LUW / DB2FORLUW / 970 - DB2

A SQL0119 error may be returned in DB2 version 9.7 Fix Pack 4 
when TO_DATE is used in a GROUP BY clause.  This can happen when 
a format-string is specified and it is a string constant.  For 
example: 
 
select to_date(DT, 'YYYYMMDD') from T group by to_date(DT, 
'YYYYMMDD') 
 
SQL0119N  An expression starting with "DT" specified in a SELECT 
clause, HAVING clause, or ORDER BY clause is not specified in 
the GROUP BY clause or it is in a SELECT clause, HAVING clause, 
or ORDER BY clause with a column function and no GROUP BY clause 
is specified.  SQLSTATE=42803

APAR fix is available in V9.7 Fixpack 5.

Rewrite the query such that the TO_DATE expression is not 
duplicated, for example: 
 
select D from ( select to_date(DT, 'YYYYMMDD') from T ) T(D) 
group by D

DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

APAR fix is available in V9.7 Fixpack 5.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

13.07.2011
12.12.2011
12.12.2011

9.7.FP5