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

 

Sorting and combining files.

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

New User


Joined: 27 Jun 2005
Posts: 36
Location: India

PostPosted: Tue Mar 31, 2009 9:37 am    Post subject: Sorting and combining files.
Reply with quote

Hi,
I have the following requirement. I know we can do this by coding three difft steps but I would like to know if it can be done in a single step:

Step 1: Extract only those records having current address effective date greater than 15th November 2008 and Field ABC not equal to X or Y. This will be file 1.

Step 2: Extract only those records having current address effective date greater than 1st February 2009 and Field ABC equal to X and Y. This will be file 2.

Step 3: Concatenate file 1 and file 2 and copy it back to File3.

File length = 250

Field description:
===============
Effective date
Length PIC X(10)/MM-DD-YYYY
Position = 20

ABC
Length PIC X(1) /Char
Position = 32

Thanks,
Hritam
Back to top
View user's profile Send private message

Frank Yaeger

DFSORT Moderator


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

PostPosted: Tue Mar 31, 2009 9:04 pm    Post subject:
Reply with quote

I don't understand your description. Are file1 and file2 separate input files or separate output files or ? Are you trying to create file1 and file2 as separate output files and then concatenate them as output file3? Why? Why not just create them as output file3 in the first place?

Please show an example of the records in the input file, or in each input file, and the expected output file or files. Show relevant values in the records for the effective date field and ABC field. Give the RECFM and LRECL of the files.

As for the position, length and format of the fields:

I think you're saying that the effective date field starts in position 20, has a length of 10 and is character format (C'MM-DD-YYYY') - right?

I think you're saying that the ABC fields starts in position 32, has a length of 1 and is character format - right?
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 High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts Efficient sorting chandracdac DFSORT/ICETOOL 5 Sat Oct 22, 2016 3:23 am
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm
No new posts Adding records from two files into on... shiitiizz SYNCSORT 4 Mon Sep 19, 2016 8:41 pm


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