BREAK CLPPlus command

The BREAK CLPPlus command inserts a page break or blank lines at the specified point in a result set.

Invocation

You must run this command from the CLPPlus interface.

Authorization

None

Required connection

You must be connected to a database.

Command syntax

Command parameters

column-name

Specifies the column used to determine a break.

SKIP PAGE | number-of-lines

Where number-of-lines is an integer.

When SKIP PAGE is appended to the command the output breaks and continues on the next page. When SKIP number-of-lines is appended to the command, the output breaks and blanks lines equal to the number-of-lines specified are inserted in the result set.

Example

In the following example, when the SELECT statement is invoked and the value of WORKDEPT changes from one row to another, the BREAK command is invoked and the action specified is performed. In this case, since SKIP PAGE was specified, the next row will be printed on the next page skipping the remainder of the current page.

    SQL> BREAK ON WORKDEPT SKIP PAGE;
    SQL> SELECT * FROM EMPLOYEE ORDER BY WORKDEPT;

In the following example, in addition to the behavior of the preceding example, every time the value in the JOB column changes, 2 blank lines are printed on the display.

    SQL> BREAK ON WORKDEPT SKIP PAGE;
    SQL> BREAK ON JOB SKIP 2;
    SQL> SELECT * FROM EMPLOYEE ORDER BY WORKDEPT, JOB;