sql - group_concat in informix -

Informix is ​​looking for a query in SQL which would simulate the MySQL group_concat function.

What makes group_concat of MySQL makes it count all the members in the group

then with the data as follows:

  orderid: itemName: value1: paper: 10 1: pen: 5 2: sugar: 15  

and the following question:

  select group_concat (itemName), the order_details group will produce  

by order ID:

  Item: Price Paper, Pen: 15 Sugar: 15  

What will be the most effective way to achieve this in Infomix? Will we definitely have to use a stored procedure?

You must define the user-defined total do this.

Iterator (ITER)

Four Parts - Four Functions (Search for 'Aggregate'):

1. Initiator (INIT) Coalition ( Combination)
2. The final word (final)

It is the official terminology in the capitals, and it is a minor intuitive, think of calculating the average.

1. Starter: Fixed amount = 0; N = 0
2. Eater: fixed amount + = x; N ++
3. Combine: set totals = sum1 + sum2; Set N = N1 + N2
4. Final form: Results = Yoga / N - N = 0 (with zero-split)

The combination of intermediate parallel execution result from; Each parallel execution starts with the intermediate and generates intermediate results. When parallel execution is complete, different values ​​are added to the compositor.

You can write the same code in IDS - using stored procedures or C or Java UDR.

See if it is implemented in Informix for a string-based GROUP_CONCAT () function.