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: 2772
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 Converting unpacked fields to pack us... SYNCSORT 4
No new posts SORT for dynamic trailer record + CSV... DFSORT/ICETOOL 14
No new posts Selective extract of multi-record-typ... SYNCSORT 4
No new posts Data for newly added fields not displ... IMS DB/DC 5
This topic is locked: you cannot edit posts or make replies. regarding COBOL WRITE verb (VB File H... COBOL Programming 9
Search our Forums:

Back to Top