How to convert multiple rows of values into a single string value in EDS or DV

Solution Verified - Updated -

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 of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In