IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

How to use OR condition in Sort card


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
atik

New User


Joined: 29 Jul 2005
Posts: 20

PostPosted: Thu Aug 25, 2005 10:50 am
Reply with quote

Hi all,
I am using Sort utility to Split the input file into 3 output file depending on a character in 3rd character

/SYSIN DD *
OPTION COPY
OUTFIL INCLUDE=(3,1,CH,EQ,C'a'),FNAMES=OUT1
OUTFIL INCLUDE=(3,1,CH,EQ,C'b'),FNAMES=OUT2
OUTFIL INCLUDE=(3,1,CH,EQ,C'c'),FNAMES=OUT3

But I want to move records to, say OUT1 if 3rd char is A or a. How to do this? If I give another OUTFIL INCLUDE with FNAMES OUT1, it is abending.
Back to top
View user's profile Send private message
jz1b0c

Active User


Joined: 25 Jan 2004
Posts: 160
Location: Toronto, Canada

PostPosted: Thu Aug 25, 2005 11:34 am
Reply with quote

Atik,

You should not give another OUTFIL INCLUDE, Perhaps you should write like below

OPTION COPY
OUTFIL INCLUDE=(3,1,CH,EQ,C'a',OR,3,1,CH,EQ,C'A'),FNAMES=OUT1
OUTFIL INCLUDE=(3,1,CH,EQ,C'b'),FNAMES=OUT2
OUTFIL INCLUDE=(3,1,CH,EQ,C'c'),FNAMES=OUT3
Back to top
View user's profile Send private message
atik

New User


Joined: 29 Jul 2005
Posts: 20

PostPosted: Thu Aug 25, 2005 11:54 am
Reply with quote

Masade,
Its working fine. Thanks a lot.
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Thu Aug 25, 2005 8:12 pm
Reply with quote

Here's another way to do it with DFSORT:

Code:

  OPTION COPY
  OUTFIL INCLUDE=(3,1,SS,EQ,C'aA'),FNAMES=OUT1
  OUTFIL INCLUDE=(3,1,CH,EQ,C'b'),FNAMES=OUT2
  OUTFIL INCLUDE=(3,1,CH,EQ,C'c'),FNAMES=OUT3


For more information on DFSORT's INCLUDE substring comparison tests (SS), see:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/3.7.4?DT=20050222160456
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top