Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Sort O/P with selection and SORT

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
nivasaya

New User


Joined: 03 May 2007
Posts: 27
Location: India

PostPosted: Thu Jun 11, 2009 4:49 pm    Post subject: Sort O/P with selection and SORT
Reply with quote

Dear Team,

I need to select only the accounts with below criteria

SORT FIELDS=COPY
INCLUDE COND= (11,2,CH,EQ,C’AD’,AND
65,2,CH,EQ,C’00’)

and as well as Sort the output based on

(1,3 and 4,19)

Please let me know if we can combine both the steps.

Thanks & Regards,
Nivasaya
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8620
Location: Back in jolly old England

PostPosted: Thu Jun 11, 2009 4:54 pm    Post subject:
Reply with quote

Yes, substitute the FIELDS=COPY with the fields that you wish sorted.
Back to top
View user's profile Send private message
nivasaya

New User


Joined: 03 May 2007
Posts: 27
Location: India

PostPosted: Fri Jun 12, 2009 9:31 am    Post subject: Reply to: Sort O/P with selection and SORT
Reply with quote

Thanks Expat. Also please let me know the following senario:

I Need to include 3 conditions:

1) SORT FIELDS=(1,22,CH,A)

2) INCLUDE 11,2,CH,EQ,C’AD’,AND
65,2,CH,EQ,C’00’
3) OMIT 1,1,CH,EQ,C’3’,AND
7,5,CH,NE,C’00003

Please let me know if this is fine:
SORT FIELDS=(1,22,CH,A)
INCLUDE COND =(11,2,CH,EQ,C’AD’,AND
65,2,CH,EQ,C’00’)
OMIT COND= (1,1,CH,EQ,C’3’,AND
7,5,CH,NE,C’00003)


Thanks & Regards,
Nivasaya

And SORT GMAD-PRIMARY-CMS-ORG and GMAD-PRIMARY-CMS-ACCT

To O/P file SORTED GMAD file.

AND eliminate AMEX accounts as well.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2287
Location: @my desk

PostPosted: Fri Jun 12, 2009 11:26 am    Post subject:
Reply with quote

nivasaya,

I dont think you can code both INCLUDE and OMIT together. And I wonder how you expected somebody here to know how to sort "GMAD-PRIMARY-CMS-ORG" and "GMAD-PRIMARY-CMS-ACCT" and eliminate "AMEX accounts".

Post some more info which makes some sense like field-positions, field lengths, field formats and keywords to identify and process records selectively.
Back to top
View user's profile Send private message
nivasaya

New User


Joined: 03 May 2007
Posts: 27
Location: India

PostPosted: Fri Jun 12, 2009 1:41 pm    Post subject: Reply to: Sort O/P with selection and SORT
Reply with quote

Sorry ARCVNS

I need to do the following conditions:

1) SORT FIELDS=(1,22,CH,A)

2) INCLUDE 11,2,CH,EQ,C’AD’,AND
65,2,CH,EQ,C’00’
3) OMIT 1,1,CH,EQ,C’3’,AND
7,5,CH,NE,C’00003

Please ignore the other info, which is irrelevent.

Thanks & Regards,
Nivasaya
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Sat Jun 13, 2009 1:31 am    Post subject:
Reply with quote

nivasaya,

Try these control cards

Code:

  INCLUDE COND=(01,1,ZD,EQ,3,AND,
                07,5,ZD,EQ,3,AND,
                11,2,CH,EQ,C’AD’,AND,
                65,2,CH,EQ,C’00’)

  SORT FIELDS=(1,22,CH,A)
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Sat Jun 13, 2009 8:43 am    Post subject:
Reply with quote

Hi Skolusu,

how does the omit come into your example ?

With your example nothing will ever be selected as byte 11 cannot be both a 3 and an A.

Gerry
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Sat Jun 13, 2009 8:53 am    Post subject: Reply to: Sort O/P with selection and SORT
Reply with quote

gcicchet,

The omit cond is looking for pos 1 , not pos 11
Quote:
OMIT 1,1,CH,EQ,C’3’,AND
7,5,CH,NE,C’00003
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Sat Jun 13, 2009 9:08 am    Post subject:
Reply with quote

Hi Skolusu,

doesn't
Code:
07,5,ZD,EQ,3,AND,
expect a value of 3 in pos 11,

and
Code:
11,2,CH,EQ,C’AD’
expect a value of A in pos 11 ?


Gerry
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Mon Jun 15, 2009 10:12 pm    Post subject:
Reply with quote

gcicchet,

I was merely trying to replicate the sort cards provided by OP and failed to notice the overlapping fields. sorry about that.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORT BUT RETAIN HIGHEST VALUE ON NON-... leondan22 DFSORT/ICETOOL 2 Thu Dec 14, 2017 8:13 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts JOINKEYS Paired and Unpaired Sort on ... MFwhiz DFSORT/ICETOOL 7 Tue Nov 07, 2017 2:46 am
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us