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

Cast Operators

Comparision Operators

BEGINS_WITH
CONTAINS
ENDS_WITH
<
>
=
<=
>=
<>

Logical Operators

AND
NOT
OR

String Operators

&

Functions

ALL()
CURRENT()
DATE()
DAYSBETWEEN()
FISCALDAY()
FISCALMONTH()
FISCALYEAR()
ISFOUND()
ISNOTFOUND()
ISNOTNULL()
ISNOTNUMERIC()
ISNOTSPACES()
ISNULL()
ISNUMERIC()
ISSPACES()
MONTHSBETWEEN()
PRIOR()
REPEAT()
RUNDAY()
RUNMONTH()
RUNYEAR()
YEARSBETWEEN()

WRITE()

Lookup Paths

Lookup Paths