Does anyone have a DB2 solution equivalent to this Oracle feature? In a
nutshell, we want to group the returned result set, separated by a blank
line.

thanks,
Ami

This is an excerpt from the Oracle documentation:"...ORACLE
SQL*Plus BREAK command creates a subset of records and add space and/or
summary lines after each subset. The column you specify in a BREAK
command is called a break column which suppresses duplicate values. For
example

SQL> BREAK ON DEPTNO SKIP 1 // To insert a blank line
SQL> SELECT DEPTNO, ENAME, SAL
2 FROM EMP
3 WHERE SAL < 2500
4 ORDER BY DEPTNO;

..."
Is there a DB2 equivalent for BREAK ON??




DB2 & UDB email list listserv db2-l LazyDBA home page