## Boolean Algebra in DFSort and Icetool

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

### Boolean Algebra in DFSort and Icetool

Hello,

I have a question regarding use of boolean algebra in DFSort an Icetool.

I know that I can use "and"- and "or"-Statements in INCLUDE COND and OMIT COND.
But if I try to write more complex statements I have the problem that I am not sure if DFSort is associative with "AND" and if I can use paranthesis.

Example:

Can I program INCLUDE CONDs for something like

(a or b) and c or d and e

INCLUDE COND ((a,or,b),and,c,or,d,and,e)

a to e could be some conditions like
"10,2,CH,EQ,C'10'"

Is this possible and does DFSort interprete the statement as (a or b) and c or (d and e) ?

regards

Oliver
olivermf

Posts: 53
Joined: Tue Feb 08, 2011 4:28 pm
Has thanked: 3 times
Been thanked: 0 time

### Re: Boolean Algebra in DFSort and Icetool

Well, the documentation for INCLUDE COND mentions AND and OR in the syntax diagrams - did you look?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator

Posts: 3026
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

### Re: Boolean Algebra in DFSort and Icetool

I finally found it in the Application and Programming Guide. Unfortunately the Reference Documentation was not helping there.

INCLUDE COND=((5,1,CH,EQ,8,1,CH),&,
((20,1,CH,EQ,C'A',&,30,1,FI,GT,10),|,
(20,1,CH,EQ,C'B',&,30,1,FI,LT,100),|,
(20,1,CH,NE,C'A',&,20,1,CH,NE,C'B')))

Thanks for the hint,

Regards

Oliver
olivermf

Posts: 53
Joined: Tue Feb 08, 2011 4:28 pm
Has thanked: 3 times
Been thanked: 0 time

### Re: Boolean Algebra in DFSort and Icetool

olivermf wrote:I finally found it in the Application and Programming Guide. Unfortunately the Reference Documentation was not helping there.

Oliver,

I guess you haven't looked in the right place. The Relational Condition section under INCLUDE Control Statement clearly mentions about the rules of using Relational conditions with AND or OR
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu

Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times