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
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: 2572
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 Record count of RECFM=U tape file DFSORT/ICETOOL 17
This topic is locked: you cannot edit posts or make replies. Write Character to Hexadecimal file w... COBOL Programming 8
No new posts Checking the total counts inside a re... JCL & VSAM 5
This topic is locked: you cannot edit posts or make replies. Passing a field name to COBOL program COBOL Programming 10
No new posts Hexadecimal Group compare and write t... DFSORT/ICETOOL 5
Search our Forums:

Back to Top