How to concatenate rows together?

by | Aug 11, 2008

Say, you want to concatenate all rows of a column and show it as a single row in the same fashion aggregate function works. $ db2 “create table t1(line# int not null, word varchar(20))” $ db2 “insert into t1...