DQL Statements › WHEN/DO Statements › Page Break

Page Break

Purpose

In addition to performing mathematical functions on a control break, you can also specify a page break. This option allows you to start report output related to a specified control break on a new page.

Syntax Diagram

The syntax for specifying a page break at a control break is:

►►─ WHEN ─ table-name ─┬────────────┬─ named-control-breakBREAKS ─────────────►
                       └─ (status) ─┘

 ►─ DO PAGE-BREAK ─┬──────────────────────────┬───────────────────────────────►◄
                   └─ PICture 'edit-pattern' ─┘

Repeat WHEN statement once for each function or page break wanted. Multiple DO statements may be used with one WHEN statement.

Explanation

The following explains the preceding format.

table-name

Refers to the specific table which contains the designated column or key which follows. It is not needed if it is the same as the most recently named table in the query.

(status)

(Optional) If authorized, use to specify a Datadictionary definition of a table that is being tested by programmers responsible for its maintenance. If the FIND or COUNT statement specifies a TEST status for a table, all subsequent statements in the same query reference the same status and version of the table, unless a different status is specified. The following describes each status you can specify.

Note: The status must be enclosed in parentheses, and there must be no spaces between the table name and the left parenthesis.

TEST

Finds the named table in the first test version that meets the specifications.

Tnnn

(Where nnn refers to the version number of the test status you want.) Finds the named table in the specified test version.

PROD

PRODuction is the default status if not specified.

named-control-break

Specifies the name of a column or key which was designated as a control-break in a SORT statement.

BREAKS

Used only for readability.

PAGE-BREAK

You can have CA Dataquery start a new page or new screen every time the value in a specific control break changes. (WHEN/DO PAGE-BREAK does not operate with totals-only.)

PICTURE

(Optional) Specifies that the data should be formatted according to the edit pattern specified next.

'edit-pattern'

A series of characters that specify how you want the data to be formatted. See PICTURE Clause.