RPT

The RPT keyword is a field qualifier that repeats a single-valued item on each line.

Format

field RPT

where

The RPT field qualifier applied to a single-valued item causes the item value to be repeated on each line when the report includes multi-valued items in other columns. It is related to the REPEATING keyword which is equivalent to using RPT on every single-valued item included in the report.

Use of RPT with a data item that is defined in the dictionary as being multivalued either explicitly (C/D/E/I-type) or implicitly (A/S-type) forces the query processor to treat the data as single valued.

Example

A file containing a multivalued list of order numbers corresponding to each customer might produce a report that includes the following section:

LIST CUST.SALES DATE ORDER.NO HDR.SUP

Customer   Date       Order No

1447       12 Jan 19  10045

1587       14 Jan 19  10051

                     10059

Using the RPT field qualifier on the DATE field changes this to:

LIST CUST.SALES DATE RPT ORDER.NO HDR.SUP

Customer   Date       Order No

1447       12 Jan 19  10045

1587       14 Jan 19  10051

          15 Jan 19  10059

See also:

REPEATING