Designing Functions › Action Diagrams › The Validate Subfile Record Construct

The Validate Subfile Record Construct

Note the hidden ...Validate subfile record construct that results when you expanded the ...Validate subfile construct. Validation of subfile record input is carried out on any subfile records that have been changed by the end user. Subfile record fields and relations are automatically validated according to the specifications declared in the design process. This is summarized as follows:

• Fields must satisfy their data types; for example,

  Date of birth must be a valid date.

  Horse value must be numeric. Note that zero is valid because it is an optional relation.

  Horse name must be present and lower case is valid.

• Fields must satisfy any check conditions; for example,

  Horse gender must be male (M) or female (F).

• Any file-to-file relationships must be satisfied; for example,

  Dam code, if specified, must be the code of a valid horse. In addition, the horse must be female because the HORSE Refers to HORSE For Dam relation uses the Mares access path that selects female horses only.

  Sire code, if specified, must be the code of a valid horse. The horse must be male because the HORSE Refers to HORSE For Sire relation uses the Stallions access path that selects male horses only.

Type Z against ...Validate subfile record.

Press Enter.