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
 

 

Spliting a file and creating a new one based on record type

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

Active User


Joined: 27 May 2008
Posts: 121
Location: India

PostPosted: Tue Jan 19, 2010 7:39 am    Post subject: Spliting a file and creating a new one based on record type
Reply with quote

Hello everyone,

I need a file(say FILE4) whose maximum no. of fields are avaialable in a file(say FILE1) based on record type- 3(record type is a field in FILE1), other fields in the FILE4 are available in FILE1 based on record type-4.

Key field in FILE1 is Account number field.

Please let me know how i can achieve it.

What i feel is that, i can split FILE1 based on record type.

After splitting i will have 2 files say FILE2 and FILE3.

I'll join these 2 files to create FILE4 based on Account number and include the fields which are required from both FILE2 and FILE3.

Please let me know if i am correct, if so please provide me the syntax.

If you have some other approach then do let me know with syntax.

Thanks.
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: Tue Jan 19, 2010 10:01 am    Post subject:
Reply with quote

Hello,

Post good examples of the input data, what you want for output from that example data and the rules for getting from the input to the output.

Also mention the recfm and lrecl of each file.
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 SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm


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