INCLUDE COND in SORT card



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

INCLUDE COND in SORT card

Postby ashwin1990 » Fri Aug 01, 2014 2:55 pm

If i have a variable with a value (say VAR = 10), can i use it in INCLUDE COND to get value that are equal to (VAR+5)?
ashwin1990
 
Posts: 32
Joined: Mon Feb 27, 2012 4:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE COND in SORT card

Postby BillyBoyo » Fri Aug 01, 2014 3:16 pm

How difficult is it to look in your manual, and to just try it?

I'm not even sure what you are asking. Can you show sample input and expected result?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: INCLUDE COND in SORT card

Postby ashwin1990 » Fri Aug 01, 2014 3:26 pm

Input file:
15
15
15

Value of VAR:10


I want to fetch data from input file using VAR.

Do we have something like
INCLUDE COND=(1:2,zd,eq,(var+5))
ashwin1990
 
Posts: 32
Joined: Mon Feb 27, 2012 4:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE COND in SORT card

Postby BillyBoyo » Fri Aug 01, 2014 3:40 pm

And where does VAR exist? Why can't you just add five to it? Also, note that 1:2 is not valid, you mean 1,2?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: INCLUDE COND in SORT card

Postby ashwin1990 » Fri Aug 01, 2014 4:03 pm

VAR exists in SYMNAME.

Yes its 1,2
ashwin1990
 
Posts: 32
Joined: Mon Feb 27, 2012 4:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE COND in SORT card

Postby BillyBoyo » Fri Aug 01, 2014 4:50 pm

Well, I'd suggest you make another symbol/SYMNAME which is VAR (I hope that that is a meaningful name) plus five and use that.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post