Extract-Phase Column Logic (ECL)
Introduction
The function of Extract-Phase Column Logic is to populate output columns with field values, constants, or the results of calculations.
Language Constructs
COLUMN and COL.nn statements
IF statements
Arithmetic Operators
+
-
*
/
Cast operators
Comparision Operators
BEGINS_WITH
CONTAINS
ENDS_WITH
<
>
=
<=
>=
<>
Logical Operators
AND
NOT
OR
String Operators
& String Concatenation
Functions
ALL()
CURRENT()
DATE()
DAYSBETWEEN()
FISCALDAY()
FISCALMONTH()
FISCALYEAR()
ISFOUND()
ISNOTFOUND()
ISNOTNULL()
ISNOTNUMERIC()
ISNOTSPACES()
ISNULL()
ISNUMERIC()
ISSPACES()
MONTHSBETWEEN()
PRIOR()
REPEAT()
RUNDAY()
RUNMONTH()
RUNYEAR()
SUBSTR()
YEARSBETWEEN()