Page 1 of 1

Splitting DB2 results

PostPosted: Sun Sep 24, 2017 11:59 pm
by Raja190
Hi All,

I would like to split my DB2 results with a page breaker like below. Could you please help me find the syntax.

Current Result:

Column_1 Column_2 column_3
----------+-------------+-------------+--------
Value_1 value_2 value_3




New result expected:


Column_1 Column_2
----------+-------------+--
Value_1 value_2


Column_3
-------------+
Value_3

Re: Splitting DB2 results

PostPosted: Mon Sep 25, 2017 2:17 pm
by NicC
You have been here long enough to know to use the code tags when posting data and code.

DB2 is a storage and retrieval mechanism not a programming language. You want your data formatted? Get your program to do that. It is much more efficient.