Field-List Clause

The field-list clause is used in data retrieval commands and specifies the fields in the designated record type to be included in the report.

The field-list clause overrides the ALL/NONE option in effect at signon, as well as any previously specified FIELDS FOR command or field-list clauses for the named record type. The established field list for a record remains in effect until another field list is specified for that record.

Enclose field-list in parentheses when you use it in a retrieval command.

Syntax:

►►─┬─ ALL ────────────────────────────────────────┬───────────────────────────►◄
   ├─ NONE ───────────────────────────────────────┤
   │ ┌──────────────────── , ───────────────────┐ │
   └─▼- field-name ─┬─────────────────────────┬─┴─┘
                    │     ┌───── , ─────┐     │
                    └─ ( -▼- subscript ─┴─ ) ─┘

Syntax rules:

ALL/NONE

Specifies whether all or none of the fields within a retrieved record type are included in the internal field list for that record.

Filler fields are not displayed unless OPTIONS=FILLER is specified.

field-name

Specifies one or more fields within a retrieved record type included in the internal field list for that record. Keep in mind these rules when specifying field-name:

Specification of a group item automatically places all elementary fields within the group item in the internal field list.
Specification of an elementary field name refers to that field name only.
Fields that redefine other fields aren't placed in the internal field list unless specified individually.

(subscript)

Specifies one or more occurrences of a repeating field. Each occurrence is identified by a subscript enclosed in parentheses. Multiple entries are separated by commas and are limited to the number specified in the OCCURS clause of the schema record description. If a repeating field name is specified without a subscript, a second set of parentheses is required.

If a repeating field is specified with one or more references to a repetition, only the specified repetitions are displayed. These rules apply to nested repeating fields:

Specifying a high-level field displays all associated repetitions of lower-level fields.
Specifying a low-level field displays that repetition of the low-level field in all repetitions of the high-level field.
Specifying a low-level field followed by a two- or three-part subscript (the repetition of the high-level field and the repetition of low-level fields) displays a single repetition of that field.

For more information:

Command Summary

Coding Considerations