Select/Omit Type
Mandatory.
Specify the operation that is to be performed against the field nominated in the "field" field.
Default=Range.
Rules
Allowable values are :
- RANGE(<low value> <high value>) which indicates that the nominated field 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 field in the file definition. Refer to S/O Range and S/O Range To.
- VALUES(<value1> <value2> .... <value100>) which indicates that the nominated field 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 field 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 field in the file definition.
- ALL which is only ever used as the last select/omit statement associated with a logical view/file. 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.