Extract-Phase Record Logic (ERL)
Introduction
Extract-Phase Record Logic is used to override the default WRITE for a view. If there are no WRITE statements in any column’s Extract-Phase Column Logic, there must be at least one WRITE statement in the Extract-Phase Record Logic.
Language Constructs
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