RE: SQL LISTAGG() built-in function

Ron,

No I don's use any SQL Option's I used the following SQL with 2 Tables
ITEM with mulitple Text-Lines.

It works fine. I'm on V7R3M0 with the latest PTF

It Works both in ACS SQL Script and 5250 Session STRSQL

----------------------------------------------------------
drop table qtemp.tempFile ;

CREATE TABLE qtemp.tempFile AS
(SELECT ITART AS ITEM, CAST(LISTAGG(TRIM(ITTXT), ' ; ' ON
OVERFLOW TRUNCATE) AS CHAR(150)) AS Text
FROM lgdtalib.pgaar
JOIN lgdtalib.pgait
ON ARWB = ITWB
AND ARART = ITART
AND 'D ' = ITLNG
GROUP BY ITWB,
ITART
HAVING COUNT(*) > 1
ORDER BY ITWB,
ITART)
WITH DATA ;

select * from qtemp.tempfile ;

ITEM TEXT

101010 Satteldach über 1 Garage ; Achtung: Garagentyp, Dachneigung, Eindeckung, ; Entwässerung muß unbedingt angegeben
werden!! ; Satteldach über 1 Garage ;



-----------------------------------------------------------------

Best regards
Burkhard

ZAPF GmbH
Nürnberger Strasse 38 - 95448 Bayreuth - Telefon (09 21) 6 01-0 - Telefax (09 21) 6 01-6 77
Sitz der Gesellschaft: Bayreuth - Registergericht: AG Bayreuth HRB 3204
Geschäftsführer: Emmanuel Thomas, Jörg Günther
info@xxxxxxxxxxxx - www.zapf-gmbh.de