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

Postby olivermf » Thu Mar 10, 2011 12:14 pm

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) ?

Thank you all in advance,

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

Postby NicC » Thu Mar 10, 2011 3:30 pm

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: 3025
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

Postby olivermf » Thu Mar 10, 2011 4:04 pm

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

Postby skolusu » Thu Mar 10, 2011 11:01 pm

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


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post