FairCom RTG COBOL Edition User's Guide

<filter> filters element

The <filter> element defines the rule identifying records belonging to a schema. The filter element will contain only one of the operator elements specified below. Every filter element should match with a $XFD WHEN clause.

<table>

<!-field tags>

</filter>

</filters>

</table>

The filters element is used to specify how records will be filtered between the various record schemas, as SQL tables may only have one record schema defined per table.

FairCom RTG COBOL - Every filter element should match with a $XFD WHEN clause.

Operator Elements

Element	Description
<eq>	If this tag is used the filter will be based on an equal comparison.
<neq>	If this tag is used the filter will be based on a not equal comparison.
<lt>	If this tag is used the filter will be based on a less than comparison.
<lte>	If this tag is used the filter will be based on a less than or equal comparison.
<gt>	If this tag is used the filter will be based on a greater than comparison.
<gte>	If this tag is used the filter will be based on a greater than or equal comparison.
<other>	If this tag is used the filter will match any record not matching any other filter.
<always>	If this tag is used the filter will always match.

Mandatory Attributes

Attribute	Description
number	An increasing number to uniquely identify filters.
table	The name of the SQL table which will be generated by this filter rule. It requires a <schema> element with the same name.