Results-To-Text , Programatically

Question

Post reply

Results-To-Text , Programatically

homebrew01

SSC Guru

Points: 55548
More actions
September 28, 2021 at 9:03 pm

#3934315
I sometimes run queries against an IBM DB2 database, using an old Navigator tool that has limited functions. In some cases I want the results in 1 pane, so I can do various string searches with CTL-F.
Typical # of result rows is less than 1000.
It's probably equivalent to SQL 7 as far and functionality goes.
Is there a way to write a query to dump all the result rows, with line breaks, into 1 result ?
- This topic was modified 3 years, 1 month ago by homebrew01.
- This topic was modified 3 years, 1 month ago by homebrew01.
- This topic was modified 3 years, 1 month ago by homebrew01.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

ratbak Ten Centuries Points: 1358 More actions · Answer 1

A quick search for IBM DB2 equivalent of SQL Server STRING_AGG leads to the LISTAGG function in DB2.

homebrew01 SSC Guru Points: 55548 More actions · Answer 2

That might work if I can figure out how to get line breaks after each row.

Jeff Moden SSC Guru Points: 1004324 More actions · Answer 3

homebrew01 wrote:

That might work if I can figure out how to get line breaks after each row.

CHR(10) should work as the "separator".

https://www.ibm.com/support/producthub/db2/docs/content/SSEPGG_11.5.0/com.ibm.db2.luw.sql.ref.doc/doc/r0000778.html?pos=2

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)