Sri h Kolusu wrote: >When you used INCLUDE COND=(5,1000,SS,EQ,X'D67DFBB0113C7464') and have VLSHRT >option, VLSHRT tells DFSORT to treat any comparison involving a short field as >false. In this case, any records less than 5+1000 = 1005 bytes are not >included. >When you used INCLUDE COND=(5,8000,SS,EQ,X'D67DFBB0113C7464') and have VLSHRT >option, So VLSHRT tells DFSORT to treat any comparison involving a short field >as false. In this case, any records less than 5+8005 = 8005 bytes are NOT >included. >So in the 2nd case unless the records have a minimum length of 8005 , DFSORT >is not going to include them and hence the reason for less number of records.
This makes sense, so the records must be x long this long before being included for comparision. Thanks, now I understand. >You need to use VLSCMP instead of VLSHRT >VLSCMP tells DFSORT that you want to temporarily replace any missing compare >field bytes with binary zeros, thus allowing the short fields to be validly >compared (the binary zeros are not kept for the output records). Thanks for this magic wand: I used this (on another dataset where I certainly know there are more of this STCK timestamp): OPTION VLSCMP OUTFILE FNAMES=PRINT,INCLUDE=(5,8000,SS,EQ,C'D67DFBB0113C7464') .. and got this nice output: ICE054I 0 RECORDS - IN: 1538864, OUT: 1538864 ICE227I 0 PRINT : DELETED = 1399576, REPORT = 0, DATA = 139288 ICE228I 0 PRINT : TOTAL IN = 1538864, TOTAL OUT = 139288 Many thanks for SORTING me out! I really appreciate it much. Thanks Sri and please keep it up! Groete / Greetings Elardus Engelbrecht ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
