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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Adding big TEXT lines to each record ... bshkris SYNCSORT 4 Sat May 06, 2017 1:40 am
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 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 Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am


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