IBM Mainframe Forum

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

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.