Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in


ICETOOL/ DFSORT.... to do Series of Sorting by filtering the

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

New User

Joined: 13 Mar 2010
Posts: 1
Location: Pune

PostPosted: Sun Oct 24, 2010 1:02 am    Post subject: ICETOOL/ DFSORT.... to do Series of Sorting by filtering the
Reply with quote

Hi Frank,

Following is my Requirement.

I have a file of LRECL=114 bytes. I have to perform a series of Sort steps on this file in order to get the final file.
Layout of file and a sample record are as follows

Tken Number(20)|Owner Name(24)|id(4)|Card number(20)| Policy numb(25)|Branch code(2)|Agent(3)|Currency(3)|Date(4 in PD)|Table code(9)
1234567897845| Ravi Kavrani | 3454 | 3243432443434 | 23123214141 | PN | ABC | GBP | 2131 | 5PQWERT

Now i have to filter this file on five different Fields. Input will given thorugh JCL Override and the sorting steps should be written in a Proc. These inputs are user defined and the user may or may not specify them...

1) At first step the input file should be filtered on the Basis of Table Code provided as input through JCL override. The filtered file will be input to the next step. I am
If the input is not provided then entire input file should be copied to input file of next step.
2) In the next step, The filtered file will be filtered further on the basis of currency code.
3) The third filter is the one which is causing the most problem. In this filter input will be Date or a range of dates. Now the Date on my input file is Fixed Dec(7) which PD field of 4 bytes. The user may give a date or a Range of Dates based on which filtering needs to be done. But the Date will be input as YYYYMMDD or YYYY/MM/DD. I need to first convert it to PD and then based on the input, Single Date or Range of Dates, i need to produce the output. I am not able to get this filter.
4) Next filter will on Branch code.
5) Next filter will be on combination of Branch and agent id.

After all these filters , the final sorting is to arrange the records in ascending order of policy numbers... I am able to get the 1,2,4 and 5 filter, but i am not able to code the third filter based on premiumDates .. as it has two possibilities.. single dat and range of dates.. Can u tell me any icetool or dfsort step.. which will achieve that...

Back to top
View user's profile Send private message

dick scherrer

Site Director

Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun Oct 24, 2010 9:36 am    Post subject:
Reply with quote

Hello and welcome to the forum,

Hopefully, i misunderstand the approach being taken. . .

If this is being done with 5 separate processes, the approach needs to be re-thought. There is no good reason to pass the filtered data 5 times to eventually get to the needed output. . .

If the other filtering code is understood, i do not understand why the "3rd" filter is a problem. Why can't the process determine if one or two values are present and filter accordingly.

If you post the jcl and control statements (for the entire process) written so far, someone may have a suggestion.
Back to top
View user's profile Send private message

Active User

Joined: 09 Apr 2008
Posts: 133
Location: Phoenix, AZ

PostPosted: Mon Oct 25, 2010 1:55 pm    Post subject:
Reply with quote

Hi Ravi,

You have given the Rules to achieve output. But you have not posted the output data how you want.
Kindly show us the the example of your INPUT & OUTPUT date and User Input for at least for 3 step.

Is there any specific reason to use different steps for each requirement? Why cont you reduce the steps to try to achieve in single pass?
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 Efficient sorting chandracdac DFSORT/ICETOOL 5 Sat Oct 22, 2016 3:23 am
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts Stripping and Sorting of VB file G SRINIVASA RAO SYNCSORT 5 Wed Sep 14, 2016 1:34 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm

Back to Top
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us