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 Sorting of hex values Saurabh_mi DFSORT/ICETOOL 11 Thu May 25, 2017 3:49 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. Merge two files and update Trailer re... Yashashri JCL & VSAM 1 Thu May 04, 2017 12:54 pm
No new posts Dynamic split of files under groups sril.krishy DFSORT/ICETOOL 4 Mon Apr 17, 2017 1:09 pm
No new posts Compare two files and subtract values ameetmund DFSORT/ICETOOL 7 Fri Mar 31, 2017 3:35 pm


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