Function RUNMONTH

TABLE OF CONTENTS

  1. What is RUNMONTH?
  2. How do I use RUNMONTH?
  3. Syntax
  4. Rules for the syntax
  5. Examples: RUNMONTH function in ERF
  6. Examples: RUNMONTH function in ECL

What is RUNMONTH?

The RUNMONTH function is dependent on the run date, or execution date of the GenevaERS extract job. The default run date is the date when the extract job is run. You can override the run date with the extract job parameter RUN_DATE, to make the job appear to run on a different date.

See GVBMR95 parameters.

All views in the extract job batch use the same run date.

RUNMONTH returns a CCYYMM format date based on the run date, plus or minus the number of months specified in the parameter.

How do I use RUNMONTH?

The parameter for RUNMONTH is a number of months to add or subtract from the default RUNMONTH. For example, RUNMONTH(-5) provides the date five months before the date the view is run.

RUNMONTH can only be used in Extract-Phase Logic.

(Syntax Legend)

Syntax

Function RUNMONTH 1

Rules for the syntax

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

See also topic: Rules for all Logic Text

Examples: RUNMONTH function in ERF

Example logic text Meaning
IF ({field2} >= RUNMONTH(-1))
    THEN SELECT
ENDIF		 Select any input records where field2 is the previous month or later,
and skip all other records.
The example at left assumes that field2 is a month number.
The code at left can also be written as:
    SELECTIF({field2} >= RUNMONTH(-1))

Examples: RUNMONTH function in ECL

Example logic text Meaning
COLUMN = RUNMONTH() Set current column to the same month number as the view is run.