COL.nnn (Format-Phase Record Filter)
TABLE OF CONTENTS
- How do I use COL.nnn in FRF?
- Syntax for COL.nnn in FRF
- Examples: SELECTIF with COL.nnn (FRF)
- Examples: SKIPIF with COL.nnn (FRF)
How do I use COL.nnn in FRF?
COL.nnn can only appear in an inquiry (for example “IF (COL.nnn = ? “ ) in the format phase. In Format-Phase Record Filter, nnn can be any column in the view.
Note that the COLUMN statement is not allowed in Format-Phase Record Filter.
Syntax for COL.nnn in FRF
Rules for the syntax
COL.nnn can only appear in an inquiry (for example “IF (COL.nnn = ? “ ) in the format phase. In Format-Phase Record Filter, nnn can be any column in the view.
See also topic: Rules for all Logic Text
Examples: SELECTIF with COL.nnn (FRF)
| Example logic text | Meaning |
|---|---|
| SELECTIF(COL.3 > 1000) | Select for output only those records with column 3 greater than 1000. Skip all other records. |
| SELECTIF(COL.2 = “ABC”) | Select for output only those records with column 2 equals “ABC”. Skip all other records. |
| SELECTIF(NOT COL.2 = “ABC”) | Select for output only those records with column 2 not equal to “ABC”. Skip all other records. This example gives the same result as: SKIPIF(COL.2 = “ABC”) |
| SELECTIF(COL.2 = “A” OR COL.2 = “D”) |
Select for output only those records with column 2 equal to “A” or “D”. Skip all other records. |
| SELECTIF(COL.2 = “A” AND COL.3 > 10) |
Select for output only those records with column 2 equal to “A” and column 3 greater than 10. Skip all other records. |
| SELECTIF(COL.3 + Col.4 > Col.5) | Select for output only those records with column 3 plus column 4 greater than column 5. Skip all other records. |
| SELECTIF(NOT COL.6 = “\xFF”) | Select for output those records with column 6 is not equal to hexadecimal FF. Skip all other records. This example gives the same result as: SKIPIF(COL.6 = “\xFF”) |
Examples: SKIPIF with COL.nnn (FRF)
| 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 equals “ABC”. Select all other records. |
| SKIPIF(NOT COL.2 = “ABC”) | Skip for output those records with 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 greater than column 5. Select all other records. |
| SKIPIF(COL.6 = “\xFF”) | Skip for output those records with column 6 equal to hexadecimal FF. Select all other records. |