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

Posts: 36
Joined: Mon Dec 14, 2015 8:13 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Splitting DB2 results


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.
Global moderator
Posts: 2782
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 114 times

Return to DB2