IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Break a record into fields, each field write a new record
IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic Quick References
View previous topic :: View next topic  
Author Message
jackare

New User


Joined: 27 Aug 2008
Posts: 35
Location: Brazil
PostPosted: Thu Oct 08, 2020 5:26 am
 Reply with quote
Hello people!
Can anybody help me?
I need to generate multiple records from certain positions / fields (fixed layout) of a Dataset, fixed block.
Something similar to the Transpose function of MS Excel.

Input Layout (fields address)
(1,3) - Key
(5,10) - Date (dd.mm.yyyy)
(15,5) - Score
( 21,6) - Name


Input:
Code:
002 01.10.2020 20000 PETER
008 01.10.2020 28000 MARY
020 07.10.2020 25000 ROBERT


Output (I need this):
Code:
002
01.10.2020
20000
PETER
008
01.10.2020
28000
MARY
020
07.10.2020
25000
ROBERT
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3051
Location: NYC,USA
PostPosted: Thu Oct 08, 2020 6:21 am
 Reply with quote
ibmmainframes.com/about55540.html
Back to top
View user's profile Send private message
jackare

New User


Joined: 27 Aug 2008
Posts: 35
Location: Brazil
PostPosted: Fri Oct 09, 2020 5:06 am
 Reply with quote
Rohit Umarjikar wrote:
http://ibmmainframes.com/about55540.html

Thanks !
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 

Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts FINDREP - Only first record from give... DFSORT/ICETOOL 3
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us