How to convert multiple rows of values into a single string value in EDS or DV
Issue
- If I have a table that has a string column with many rows (say 'A', 'B', 'C') what's the best way to produce a single string: 'A B C'.
- Need to return a dataset as a single string value
- Is there String aggregate function for Concatenating with delimiter in EDS 5.3.1 that we can use, without writing virtual procedure or custom scalar function ?
Environment
- Red Hat JBoss Data Services (EDS) 5.2, 5.3.1
- Red Hat JBoss Data Virtualization (DV) 6.0, 6.1, 6.2, 6.3
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.