At the select/omit-field level, you can specify a field name, a value, or *NULL for the parameter.
If the select/omit field is a Binary character field, the field-name parameter must also be a Binary character field. The comparisons for Binary character select/omit fields will also need to take the actual lengths of the operands into consideration. The operands will only compare as equal if the actual lengths of the operands are equal. Shorter operands will be considered less than the longer operands when they are equal up to the length of the shorter operand.
If you specify a value, the following rules apply:
Specify character strings with apostrophes (see example 1 above).
Specify hexadecimal character strings as an X followed by a combination of the digits 0 through 9 and the letters A through F, enclosed in apostrophes. The number of hexadecimal digits in apostrophes must be exactly twice the specified length of the field (see example 2 above).
COMP(EQ 'YYYY-MM-DD-HH.MM.SS.UUUUUU')
If you specify *NULL, the relational operator must be EQ or NE.
COMP selects or omits records retrieved from the physical file on which this logical file is based when your program sends an input operation to the record format you are defining. The OS/400 program selects or omits records as a result of testing the value of the select/omit fields against the value you specify, the value of the field whose name you specify, or the null value (if *NULL was specified).
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.