Extract-Phase Record Filter (ERF)
Introduction
The function of Extract-Phase Record Filter is to include or exclude records, based upon specific criteria. The Extract-Phase filtering performs filtering on the input records.
Extract-Phase Record Filters:
- Select source records to process.
- Are performed first, before any other criteria.
- If omitted, all records will be selected as input.
Language Constructs
SELECT and SELECTIF
SKIP and SKIPIF
IF Statements
Arithmetic Operators
+
-
*
/
Cast operators
Comparision Operators
BEGINS_WITH
CONTAINS
ENDS_WITH
<
>
=
<=
>=
<>
Functions
ALL()
CURRENT()
DATE()
DAYSBETWEEN()
FISCALDAY()
FISCALMONTH()
FISCALYEAR()
ISFOUND()
ISNOTFOUND()
ISNOTNULL()
ISNOTNUMERIC()
ISNOTSPACES()
ISNULL()
ISNUMERIC()
ISSPACES()
MONTHSBETWEEN()
PRIOR()
REPEAT()
RUNDAY()
RUNMONTH()
RUNYEAR()
YEARSBETWEEN()
Logical Operators
AND
NOT
OR