How you can use filter expressions

You can use filter expressions in one of two ways.

  • With the CRITERIA option of a GET or PERFORM OBJECT command to filter the resource table records returned by that command. The filter expression is used only once and is discarded when the command that used it completes its processing.
  • With a SPECIFY FILTER command to define a filter that can be used repeatedly.
    Once a filter is defined, you can use it with these commands to limit the resource table records being processed:
    • COPY
    • DELETE
    • FETCH
    • GET
    • GROUP
    • LISTEN
    • LOCATE
    • MARK
    • PERFORM OBJECT
    • PERFORM SET
    • REFRESH
    • SET
    • UNMARK
    A filter expression that you define with the SPECIFY FILTER command is available to your program until you either discard it (with the DISCARD command) or terminate the processing thread.


eyup1az.html | Timestamp icon Last updated: Sunday, 4 June 2017