Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
Posted: Thu Dec 13, 2007 2:07 pm Post subject:
So we have a 3-byte PD value that represents sddd.dd (e.g. X'12345C' represents +123.45). .0000089 divided by .00005 is 0.178 so we should be able to compare the sddd.dd value to .18. The value doesn't actually have the decimal point so we're really comparing sddddd to +18 (or +17?). Thus, the DFSORT INCLUDE statement would be:
Code:
INCLUDE COND=(1,3,PD,LT,0,OR,1,3,PD,GT,18)
Does that work? _________________ 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