This will not stand, ya know, this aggression will not stand, man.
A quick search of the internets produced this Stack Overflow post which shows how to create a User Defined Aggregate in Informix that will duplicate the MySQL group_concat aggregate.
id value 1 ABC 2 DEF 1 GHI 1 JKL 2 MNO 3 PQR select id, group_concat(value) from tab group by id; 1 ABC, GHI, JKL 2 DEF, MNO 3 PQR
Creating a User Defined Aggreate involves creating 4 support functions in SPL, C or Java.
- Initialize – Initializes the aggregate
- Iteration – Merges results of previous iterations of the aggregate with the current value
- Combine – Combines results of 2 iterations when the a…