Splitting DB2 results



IBM's flagship relational database management system

Splitting DB2 results

Postby Raja190 » Sun Sep 24, 2017 11:59 pm

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
Raja190
 
Posts: 36
Joined: Mon Dec 14, 2015 8:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Splitting DB2 results

Postby NicC » Mon Sep 25, 2017 2:17 pm

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.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to DB2