Batch Processing › SARBCH Control Statements › DEFFILT

DEFFILT

The DEFFILT control statement creates or modifies a FILTER.

Syntax:

/DEFFILT 	ID=fname
 		DESC='Up to 40 characters'
		FILTERS=( (bline,eline,bcol,ecol,op,'text',type,show,clr,hlt,loc), ... )

Where:

ID=fname

Specifies the 1-8 character name for this Filter.

DESC=

Specifies the 1-40 character Filter description.

FILTERS=

Filter specifications are defined by entries within a table.

The FILTERS parameters are enclosed in parentheses.

In addition, each entry (row) in the table is also enclosed by parentheses.

Note: To update FILTERS= definitions for an existing filter, specify all FILTERS= definitions. All existing table entries are replaced with the new entries.

Table entries have the following format:

(bline,eline,bcol,ecol,op,'text',type,show,clr,hlt,loc)

bline

The beginning line specifies the first line on the unfiltered report page that is to be searched for the data specified in the text column.

Note: If bline or eline is not specified, the entire page is searched. If only bline is specified, only that one line is searched. If both bline and eline are specified, only those lines specified (including all between) are searched.

eline

The ending line specifies the last line on the unfiltered report page that is to be searched for the data specified in the text column. If eline is specified, bline must also be specified.

See the previous note about bline and eline.

bcol

The beginning column specifies the first column on the unfiltered report page that is to be searched for the data specified in the text column.

Note: If bcol or ecol is not specified, the entire line is searched. If only bcol is specified, only that one column is searched. If both bcol and ecol are specified, only those columns specified (including all between) are searched.

ecol

The ending column specifies the last column on the unfiltered report page that is to be searched for the data specified in the text column. If ecol is specified, bcol must also be specified.

See previous note about bcol and ecol.

op

Specifies the type of comparison to be performed:

• EQ - equal to
• NE - not equal to
• LT - less than
• LE - less than or equal to
• GT - greater than
• GE - greater than or equal to text
• Specifies the text data that is being searched for on the unfiltered report page. Enclose the text in single quotes. The text searching is case-sensitive.

type

Specifies the Boolean connectors: AND, OR, NOT

The NOT connector must appear on its own line, and it refers to the line that follows it.

When using AND, all comparisons must have the same line numbers.

show

Specifies whether lines that match the specified filter criteria are displayed. If the comparison is successful, the character "Y" specifies to include the line for display or print, and the character "N" specifies to exclude the line from display or print.

This can be omitted if you only want to emphasize with color or highlighting.

clr

Specifies optional color to be applied when the comparison is successful:

• B - blue
• G - green
• P - pink
• R - red
• T - turquoise
• W - white
• Y - yellow

hlt

Specifies optional highlight to be applied when the comparison is successful:

• B - blink
• R - reverse video
• U – underscore

loc

Specifies optional location to which color, highlight, or both are applied when the comparison is successful:

• A - all occurrences of the specified text string on the report line
• F - the first occurrence of the specified text string on the report line
• L - the entire report line

If omitted when color, highlight, or both have been specified, "A" for all occurrences of the field is automatically inserted.