Topic
1 reply Latest Post - ‏2013-06-28T02:05:46Z by RuiNie
Paul_Vernon
Paul_Vernon
3 Posts
ACCEPTED ANSWER

Pinned topic LISTAGG parse error

‏2013-06-20T10:03:45Z |

Design Studio 4.1 does not parse LISTAGG when you use the WITHIN GROUP clause on a DB2 LUW 9.7 connection.

E.g. this gets underlined in red



SELECT workdept, 


LISTAGG(lastname, ', ') 
WITHIN GROUP 
( 
ORDER BY lastname 
) 
AS employees 

FROM emp     
GROUP BY workdept

This syntax is supported from Fixpack 4 of DB2 LUW.  If you manually change the validation to DB2 10.1 or 10.5 then it parses fine

Updated on 2013-06-20T10:04:43Z at 2013-06-20T10:04:43Z by Paul_Vernon
  • RuiNie
    RuiNie
    13 Posts
    ACCEPTED ANSWER

    回复:LISTAGG parse error

    ‏2013-06-28T02:05:46Z  in response to Paul_Vernon

    This should be a defect happend on db2 since Version V9.7FP4 and before V10.1