Function CURRENT

TABLE OF CONTENTS

  1. How do I use CURRENT?
  2. Syntax
  3. Rules for the syntax
  4. Examples: PRIOR and CURRENT functions in ERF
  5. Examples: PRIOR and CURRENT functions in ECL

How do I use CURRENT?

The function CURRENT may be used along with the function PRIOR. It refers to the current source record, whereas PRIOR refers to the previous record read. For any source record, you can compare the current value of a field with the value in the previous record.

CURRENT may be typed before the name of the field, for example:

     CURRENT {product_code}

This is the same as:

     {product_code}

If you use PRIOR, it is recommended you put CURRENT in front of all fields that refer to the current source record. This is not necessary but recommended because it makes the logic text much easier to understand. For example:

     IF ((CURRENT {product_code} = PRIOR {product_code}) THEN

Normally, CURRENT is used only when a statement contains PRIOR.

CURRENT and PRIOR can only be used in Extract Record Filter (ERF) and Extract Column Logic (ECL) text.

(Syntax Legend)

Syntax

Function PRIOR

Rules for the syntax

CURRENT can only be used in Extract Record Filter (ERF) and Extract Column Logic (ECL) text.

See also topic: Rules for all Logic Text

Examples: PRIOR and CURRENT functions in ERF

Example logic text Meaning
IF (CURRENT({field1}) <> PRIOR({field1}))
    THEN SELECT
ENDIF		 Select only records with unique values for field1. This assumes the input file is sorted into field1 order. This example can also be written:
    SELECTIF(CURRENT({field1}) <> PRIOR({field1}))

Examples: PRIOR and CURRENT functions in ECL

Example logic text Meaning
IF (CURRENT({field2}) <> PRIOR({field2}))
    THEN COLUMN = “PRODUCT: “
     ELSE COLUMN = “ “
ENDIF		 If the current record has a different value of field2 from the previous record, set the current column to “PRODUCT: ” otherwise set the current column to blank. This assumes the input file is sorted into field2 order.