Splitting DB2 results

IBM's flagship relational database management system
Post Reply Previous topicNext topic
Raja190
Posts: 36
Joined: Mon Dec 14, 2015 8:13 pm
Skillset: Cobol, cics, jcl, vsam, db2
Referer: google

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
Top
NicC
Global moderator
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Skillset: JCL, PL/1, Rexx, Utilities and to a lesser extent (i.e. I have programmed using them) COBOL,DB2,IMS
Referer: Google
Location: Pushing up the daisies (almost)

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
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “DB2”