SKIPIF statements
in Format-Phase Record Filter

TABLE OF CONTENTS

1. How do I use SKIPIF in FRF?
2. Syntax
3. Rules for the syntax
4. Examples: SKIPIF in Format-Phase Record Filter

How do I use SKIPIF in FRF?

In this logic text, SKIPIF defines the output records to be written in the format phase, based on a condition. The selection criteria refers to column numbers, not field names.

You can either SELECTIF or SKIPIF but you cannot do both in the same logic text. Once you have defined records to skip, then all others are written.

If there are no SELECTIF or SKIPIF statements in the Format-Phase Record Filter, then all output records are written.

The syntax details of a SKIPIF statement in Format-Phase Record Filter are shown below.

Syntax

Rules for the syntax

A Format-Phase Record Filter can only have one SELECTIF or one SKIPIF statement.

See also topic: Rules for all Logic Text

Examples: SKIPIF in Format-Phase Record Filter

Example logic text	Meaning
SKIPIF(COL.3 > 1000)	Skip for output those records with column 3 greater than 1000. Select all other records.
SKIPIF(COL.2 = “ABC”)	Skip for output those records with column 2 equal to “ABC”. Select all other records.
SKIPIF(NOT COL.2 = “ABC”)	Skip those output records with field column 2 not equal to “ABC”. Select all other records. This example gives the same result as: SELECTIF(COL.2 = “ABC”)
SKIPIF(COL.2 = “A” OR COL.2 = “D”)	Skip for output those records with column 2 equal to “A” or “D”. Select all other records.
SKIPIF(COL.2 = “A” AND COL.3 > 10)	Skip for output those records with column 2 equal to “A” and column 3 greater than 10. Select all other records.
SKIPIF(COL.3 + Col.4 > Col.5)	Skip for output those records with column 3 plus column 4 is greater than column 5. Select all other records.
SKIPIF(COL.6 = ALL(“-“))	Skip for output those records with column 6 is equal to all dashes. Select all other records.
SKIPIF(COL.6 = “\xFF”)	Skip for output those records with column 6 is equal to hexadecimal FF. Select all other records.