IBM Mainframe Forum

sergeyken wrote:

Select all

 INCLUDE COND=(field1,EQ,field2)
 . . . . . etc. . . . . .

ICE805I 1 JOBNAME: SYSTEMSB , STEPNAME: SORT2
ICE802I 0 BLOCKSET TECHNIQUE IN CONTROL
ICE143I 0 BLOCKSET COPY TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R5 - 14:17 ON MON JU
SORT FIELDS=COPY
INCLUDE COND=(59,8,SS,EQ,69,8)
$
ICE114A E INVALID COMPARISON
ICE751I 0 C5-I79519 C6-NONE C7-I76950 C8-I76518 E7-I76950
ICE052I 3 END OF DFSORT

samb01 wrote:Hello. Thank's but it didn't work because filed 2 must be a substring constant :

Select all

ICE805I 1 JOBNAME: SYSTEMSB , STEPNAME: SORT2                                  
ICE802I 0 BLOCKSET     TECHNIQUE IN CONTROL                                    
ICE143I 0 BLOCKSET     COPY  TECHNIQUE SELECTED                                
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 1 - CONTROL STATEMENTS FOR 5650-ZOS, Z/OS DFSORT V2R5  - 14:17 ON MON JU
           SORT FIELDS=COPY                                                    
           INCLUDE COND=(59,8,SS,EQ,69,8)                                      
                                    $                                          
ICE114A E INVALID COMPARISON                                                    
ICE751I 0 C5-I79519 C6-NONE   C7-I76950 C8-I76518 E7-I76950                    
ICE052I 3 END OF DFSORT                                                        
 

ICE114A INVALID COMPARISON
Last Updated: 2021-10-28

Explanation
Critical. One of the following situations exists:
The COND operand of an INCLUDE or OMIT statement, or the INCLUDE or OMIT operand of an OUTFIL statement or JOINKEYS statement, or the TRLID operand of an OUTFIL statement, or the IFTHEN WHEN, BEGIN or END operand of an INREC, OUTREC, or OUTFIL statement, contained an invalid field-to-field, field-to-mask, or field-to-constant comparison, or used a field with NUM that was not FS, CSF, PD, or ZD, or used a field with UC, LC, MC, UN, LN or MN that was not BI.
FORMAT=SS was specified after COND in an INCLUDE or OMIT statement.

Select all

 INCLUDE FORMAT=SS,COND=(11,6000,EQ,C'OK',OR,5,3,EQ,C'J69,L92,J82')

This example illustrates how to include only records in which:
OK is found somewhere within bytes 11 through 6010
OR

Bytes 5 through 7 contain J69, L92 or J82.

samb01 wrote:

Select all

SORT FIELDS=COPY                  
INCLUDE COND=(60,8,CH,EQ,69,8,CH)
 

Where is any substring???!!!