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
 
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
ravi_k03

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...

Thanks,
Ravi
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
nelson.pandian

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 Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts Join records from 2 files with No Dup... Poha Eater DFSORT/ICETOOL 22 Sun Aug 27, 2017 10:35 pm
No new posts Sorting on text - but in non-alphabet... Roy Ware SYNCSORT 5 Wed Aug 23, 2017 9:15 pm
No new posts Multiple VSAM files single output fil... Mohan Kothakota DFSORT/ICETOOL 11 Wed Aug 09, 2017 7:57 pm
No new posts Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm

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