SKIP and SKIPIF in Extract-Phase Record Filters

TABLE OF CONTENTS

1. How do I use SKIP and SKIPIF in ERF?
2. Syntax
3. Rules for the syntax
4. Examples: SKIPIF in Extract Record Filter

How do I use SKIP and SKIPIF in ERF?

In this logic text, SKIP or SKIPIF define the input records to be excluded in the extract phase.

If there are no SELECT, SELECTIF, SKIP or SKIPIF statements in Extract Record Filter, then all input records are selected.

The idea is that you either SELECT or SKIP but you cannot do both in the same logic text. Once you have selected records then all others are skipped. Alternatively, once you skip records then all others are selected.

SKIPIF defines the input records to skip based on a condition.

SKIP must always be inside an IF statement, in a THEN or ELSE case. The path through the IF statement decides which records reach the SKIP statement.

Extract Record Filter can have one SKIPIF or one IF that contains one or more SKIP statements. Once either of these is present, no SELECT or SELECTIF statements are allowed.

The syntax details of a SKIP and SKIPIF statements in Extract Record Filter are shown below.

Syntax

Rules for the syntax

Extract Record Filter can have one SELECTIF statement or one IF statement that contains one or more SELECT statements. When one SELECTIF or SELECT is present, then no SKIP or SKIPIF statements are allowed.

One IF statement can have a SELECT for the THEN or ELSE case. One IF statement can have other IF statements nested inside, which may also have SELECT statements inside. All this counts as one IF statement.

The best way to learn is the examples below. See also the examples in IF Statements in Extract Record Filter.

See also topic: Rules for all Logic Text

Examples: SKIPIF in Extract Record Filter

Example logic text	Meaning
SKIPIF(CURRENT({field4})     PRIOR({field4}))	Skip records where the new field4 value is the same as the previous field4. This assumes the input file is sorted into field4 order. This selects only the input records where field4 is a new value (compared to the previous record).
SKIPIF({field1} > 1000)	Skip for output those records with field1 greater than 1000. Select all other records. The code at left is a shorthand for:   IF {field1} > 1000      THEN SKIP   ENDIF
SKIPIF({field2} = “ABC”)	Skip for output those records with field2 equal to “ABC”. Select all other records.
SKIPIF(NOT({field2} = “ABC”))	Skip those output records with field2 not equal to “ABC”. Select all other records. This example gives the same result as:   SELECTIF({field3} = “ABC”)
SKIPIF({field3} = “A” OR     {field3} = “D”)	Skip for output those records with field4 equal to “A” and field5 greater than 10. Select all other records.
SKIPIF({field4} = “A” AND     {field5} > 10)	Select for output only those records with field3 equal to “A” and field4 greater than 10. Skip all other records.
SKIPIF({field6} * 2 > {field8}+ 5)	Skip for output those records with field6 times 2 is greater than field8 plus 5. Select all other records.
SKIPIF({field6} = ALL(“-“))	Skip for output those records with field6 is equal to all dashes. Select all other records.
SKIPIF({field6} =      REPEAT(“-“, 13))	Skip for output those records with field6 is equal to 13 dashes. Select all other records.
SKIPIF(NOT {field6} = “\xFF”)	Skip for output those records with field6 is equal to hexadecimal FF. Select all other records.
SKIPIF(ISNOTFOUND({Lookup2}))	Skip all input records where the lookup path Lookup2 does not successfully find a target record, and select all other records.
SKIPIF(ISNOTFOUND({Lookup2,field7}))	Skip all input records where the lookup path Lookup2 does not successfully finds a target record using effective date of field7, and select all other records.
SKIPIF(ISNOTFOUND({Lookup2;$SYM=”A”}))	Skip all input records where the lookup path Lookup2 using symbol SYM set to “A” does not successfully finds a target record, and select all other records.
SKIPIF(ISNOTFOUND({Lookup2,     field8;$SYM1=3,$SYM2=0}))	Skip all input records where the lookup path Lookup2 using effective date of field8 and symbol SYM1 set to 3 and symbol SYM2 set to zero does not successfully finds a target record. Select all other records.
SKIPIF(ISNULL({field1}))	Skip all input records where field1 contains null values, and select all other records.
SKIPIF(ISNOTNUMERIC({field2}))	Skip all input records where field2 is not numeric, and select all other records.
SKIPIF(ISSPACES({field3}))	Skip all input records where field3 is spaces, and select all other records.
SKIPIF(DAYSBETWEEN({field4},{field5})      > 7)	Skip only records where there are more than 7 days between field4 and field5, and select all other records.
SKIPIF({field1} BEGINS_WITH “BBB”)	Skip input records where field1 begins with characters “BBB”, and select all other records.
SKIPIF({field2} CONTAINS “CCC”)	Skip input records where field2 contains characters “CCC”, and select all other records.
SKIPIF({field3} ENDS_WITH “EEE”)	Skip input records where field3 ends with characters “EEE”, and select all other records.