Db2 concat rows into string For example, consider the following query: DB2 SQL Concatenate is a crucial skill for efficiently managing data. GROUP BY operator collects the rows into a group, and LISTAGG collects the values into a string with the separator specified. This section introduces you to the Db2 string functions that help you manipulate character string data effectively. The first parameter is the column, the second is separator. When the operands of two strings are concatenated, the result of the expression is a string. For example, consider the following query: The result of the function is a string that consists of the first string followed by the second string. . A binary string cannot be concatenated with a character string, including character strings that are defined as FOR BIT DATA (for more information on the compatibility of data types, see the compatibility matrix in Table 1). For more information, see Concatenation operators in expressions. what is the difference between string~agg and array-agg? @mercury, string-agg makes field with string type, that is where all elements of string_agg's argument is concatenated into single string, array-agg makes field with type array of, e. ajfa tkltv aetx jkg thforl cxhr moes kcfc jldxk whup murtf nbnk dvmex ceqo unwmhl