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()
LEFT()
MONTHSBETWEEN()
PRIOR()
REPEAT()
RUNDAY()
RUNMONTH()
RUNYEAR()
RIGHT()
SUBSTR()
YEARSBETWEEN()
Logical Operators
AND
NOT
OR