• Created by user-cd56b, last updated by user-5d3f2 on Dec 09, 2022 2 minute read

Select/Omit Type

Mandatory.

Specify the operation that is to be performed against the column.

Default=Range.

Rules

Allowable values are :

  • RANGE(<low value> <high value>) which indicates that the nominated column should be tested against the range of values <low value> to <high value>. The <low value> and <high value> specified can be a character literal in quotes (e.g. 'BALMAIN'), a numeric literal (e.g.  1.54) or the name of another column in the table definition. Refer to S/O Range and S/O Range To.
  • VALUES(<value1> <value2> .... <value100>) which indicates that the nominated column should be compared with the list of values specified. Up to 100 values can be specified in the list of values. The value fields specified can be a character literal in quotes (e.g. 'BALMAIN') or a numeric literal. Refer to S/O Value.

  • COMP(<operator> <value>) which indicates that the nominated column should be compared using <operator> to the <value>. Refer to S/O Operator and S/O Value. Allowable values for <operator> are:

    EQ

    Equal to

    NE

    Not equal to

    LT

    Less than

    NL

    Not less than

    GT

    Greater than

    NG

    Not greater than

    LE

    Less than or equal to

    GE

    Greater than or equal to

    The value specified for <value> can be a character literal in quotes (e.g. 'BALMAIN'), a numeric literal (e.g.  1.54) or the name of another column in the table definition.

  • ALL which is only ever used as the last select/omit statement associated with an index. It indicates what is to happen after all other select/omit statements have been processed. If used with SELECT then all records not meeting the previous select/omit statements will be selected. If used with OMIT then all records not meeting the previous select /omit statements will be omitted. If the ALL condition is NOT specified as the last statement in a set of select/omit statements then a default value is assumed. The default value is the reverse of the last select/ omit statement specified. If the last select/omit statement is SELECT then a default of OMIT ALL is assumed as the last statement. Likewise if the last select/omit statement is OMIT then a default value of SELECT ALL is assumed as the last select/omit statement.


  • No labels