REPEATING

REPEATING

Top  Previous  Next

 

The REPEATING keyword causes the query processor to repeat single valued data against further values in other fields.

 

 

Format

 

REPEATING

 

 

In a report that includes multivalued fields, the value of any single valued items normally only appears once. The REPEATING keyword duplicates the single valued items against each multivalued element of other fields.

 

The decision as to whether an item is single or multivalued is based on the S/M flag in the D/I-type dictionary definition or use of the equivalent field qualifiers, not by whether the data includes value marks. This is to ensure that a multivalued field with only a single entry does not get repeated.

 

Pick style A/S-type dictionary items are always treated as multivalued.

 

 

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 ORDER.NO HDR.SUP

 

Customer   Order No

1447       10045

1587       10051

          10059

 

Using the REPEATING keyword changes this to:

 

LIST CUST.SALES ORDER.NO HDR.SUP REPEATING

 

Customer   Order No

1447       10045

1587       10051

1587       10059

 

 

See also:

BY.EXP