The following examples show how to specify the VALUES keyword.
Figure 80 uses character and numeric values.
Figure 80. Specifying the VALUES Keyword (Example 1)
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 00010A R RECORD1 PFILE(PF1) 00020A FIELDA 1 0 VALUES(1 6 9) (1) 00030A FIELDB 1 VALUES('A' 'B' 'C') (1) 00040A K FIELDA 00050A S FIELDB VALUES('A' 'B') (2) 00060A S FIELDA VALUES(1 6) (2) A
Figure 81 uses hexadecimal values.
Figure 81. Specifying the VALUES Keyword (Example 2)
|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8 00010A R RCD1 PFILE(PF1) 00020A CODEA 00030A FLD1 00040A FLD2 00050A K FLD1 00060A S CODEA VALUES(X'51' X'54' X'AE') A
VALUES is specified as a select/omit keyword for CODEA (which is a 1-byte field). Records from physical file PF1 are retrieved through this record format only if the value of field CODEA is hex 51, hex 54, or hex AE.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.