FDREPORT BREAK Statement


BREAK statement

The BREAK statement provides a simple alternative to the SORT statement when you want to sort every field in ascending order and takes a standard control break when any value changes. In other words,

BREAK FIELDS=(A,B,C)

is equivalent to

SORT FIELDS=(A,B,C),BREAK=(YES,YES,YES)

Details are found in FDREPORT-SORT-Statement.

BREAK statement syntax

BREAK



FIELDS=(field[,field[,…]])


,RESET|NORESET

FIELDS=

field

Specifies one or more fields to be used by FDREPORT for the SORT. If more than one FIELDS= is specified, they are sorted in the order specified. All fields are sorted in ascending order.

The tables in FDREPORT-Field-Names document the available FIELDS= names. Check the SORT column to see which fields are supported for sorting.

RESET

NORESET

NORESET

Indicates that these fields should be added to the list of fields currently in effect from preceding BREAK or SORT statements.

RESET

Indicates that the list of fields on this BREAK statement completely replaces the values on any preceding BREAK or SORT statement.

Default: RESET.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*