INCLUDE COND



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

INCLUDE COND

Postby fanatik » Fri Jul 10, 2009 3:16 pm

Can you assist me in understanding this code:

INCLUDE COND=((1,6,CH,GT,C'200905'),
AND,
((133,1,CH,EQ,C'Q'),OR,(133,1,CH,EQ,C'C'))))
fanatik
 
Posts: 8
Joined: Fri Jul 10, 2009 2:38 pm
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE COND

 

Re: INCLUDE COND

Postby expat » Fri Jul 10, 2009 5:09 pm

Please refer to the SORT documentation readily available from the DFSORT forum.
expat
 
Posts: 382
Joined: Sat Jun 09, 2007 3:21 pm
Has thanked: 0 time
Been thanked: 1 time

Re: INCLUDE COND

Postby fanatik » Fri Jul 10, 2009 6:20 pm

thnx will do.
fanatik
 
Posts: 8
Joined: Fri Jul 10, 2009 2:38 pm
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE COND

Postby Frank Yaeger » Fri Jul 10, 2009 8:21 pm

It says to include the record if the value in positions 1-6 is greater than '200905', providing that position 133 has a 'Q' or a 'C'. Otherwise, omit the record.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: INCLUDE COND

Postby fanatik » Mon Jul 13, 2009 4:16 pm

Thnx Frank

with this code can I pass a date variable and test the date, and increment the date ?
fanatik
 
Posts: 8
Joined: Fri Jul 10, 2009 2:38 pm
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE COND

Postby Frank Yaeger » Mon Jul 13, 2009 8:46 pm

You can use the current date or a future date or a past date with INCLUDE. For example, for today (yyyymm):

1,6,CH,GT,DATE2

For next month (yyyymm + 1 month)

1,6,CH,GT,DATE2+1

For last month (yyyymm - 1 month)

1,6,CH,GT,DATE2-1

If you're trying to do something else, you need to explain clearly exactly what you're trying to do.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: INCLUDE COND

Postby fanatik » Tue Jul 14, 2009 5:28 pm

Thnx

Thats exactly wat i needed and for incrementing the day I would use DATE1.

Perfect.
fanatik
 
Posts: 8
Joined: Fri Jul 10, 2009 2:38 pm
Has thanked: 0 time
Been thanked: 0 time

Re: INCLUDE COND

Postby Frank Yaeger » Tue Jul 14, 2009 8:14 pm

Yes. DATE1 is a yyyymmdd date. DATE1+n would add n days.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Re: INCLUDE COND

Postby fanatik » Wed Jul 15, 2009 12:31 pm

Thnx Frank.
fanatik
 
Posts: 8
Joined: Fri Jul 10, 2009 2:38 pm
Has thanked: 0 time
Been thanked: 0 time


Return to JCL

 


  • Related topics
    Replies
    Views
    Last post