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.