But it is checking each bit and I can use this sort card only for small length fileds. But my search field length is 50 Bytes. is there any other option in Sort?
Joined: 26 Nov 2002 Posts: 12370 Topics: 75 Location: San Jose
Posted: Mon Apr 03, 2006 5:00 am Post subject:
Quote:
But it is checking each bit and I can use this sort card only for small length fileds. But my search field length is 50 Bytes. is there any other option in Sort?
gharidoss,
Just expand the field declaration. For binary fields you can check with 2,4,8 bytes. so split the 50 bytes and perform the checking as shown below.
Code:
INCLUDE COND=(01,08,BI,ALL,X'F0F0F0F0F0F0F0F0',OR,
09,08,BI,ALL,X'F0F0F0F0F0F0F0F0',OR,
17,08,BI,ALL,X'F0F0F0F0F0F0F0F0',OR,
25,08,BI,ALL,X'F0F0F0F0F0F0F0F0',OR,
33,08,BI,ALL,X'F0F0F0F0F0F0F0F0',OR,
41,08,BI,ALL,X'F0F0F0F0F0F0F0F0',OR,
49,02,BI,ALL,X'F0F0')
Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Mon Apr 03, 2006 11:17 am Post subject:
Quote:
For binary fields you can check with 2,4,8 bytes
For DFSORT's INCLUDE, BI fields can be up to 256 bytes, so this can be done using 1,50,BI,...
Code:
INCLUDE COND=(1,50,BI,ALL,X'F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0X
F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0F0X
F0')
Hari,
The X'F0F0...F0' mask checks for F0-FF in each byte. It does not check for alphanumerics vs non-alphanumerics. Please clarify what exactly it is you want to do and why you think the X'F0F0...F0' mask does it. _________________ Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
