S O Range

LANSA Technical

S/O Range

These fields must be specified if the Select/Omit Type is Range.

Range From

Mandatory.

Specify the lower value that the select/omit filed should be compared to.

Rules

Allowable values are:

  • Character literal in quotes (e.g. 'BALMAIN').
  • Numeric literal (e.g.  1.54).
  • DateTime literal in quotes. (e.g. '2005-05-01 10:00:00')
    DateTime literals need to be entered as per the SUTC attribute of the field.
    If the SUTC attribute is enabled, enter the value as UTC, otherwise enter the value in local time.
  • Name of another field in the file definition.

S/O Range To

Mandatory.

Rules

Allowable values are:

  • Character literal in quotes (e.g. 'BALMAIN').
  • Numeric literal (e.g.  1.54).
  • DateTime literal in quotes. (e.g. '2005-05-01 10:00:00')
    DateTime literals need to be entered as per the SUTC attribute of the field.
    If the SUTC attribute is enabled, enter the value as UTC., otherwise enter the value in local time.
  • Name of another field in the file definition.

Ý 3.4.3 Select/Omit Criterion