Portal | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Break a record into fields, each field write a new record

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
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    Post subject: Break a record into fields, each field write a new record
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: 2487
Location: NY,USA

PostPosted: Thu Oct 08, 2020 6:21 am    Post subject:
Reply with quote

http://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    Post subject:
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    IBMMAINFRAMES.com Support Forums -> SYNCSORT All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copying data from prev record using SORT bshkris SYNCSORT 19 Thu Oct 15, 2020 3:29 pm
No new posts BMS map length field greater than zero Ziko13 CICS 3 Fri Oct 09, 2020 5:40 pm
No new posts Creating a single-record file with CO... Joerg.Findeisen DFSORT/ICETOOL 8 Tue Oct 06, 2020 8:19 pm
No new posts SYNCSORT Error - CONTROL FIELD BEYOND... arunn SYNCSORT 10 Sun Oct 04, 2020 4:10 pm
No new posts How do i verify the char field is hav... Raghu M N PL/I & Assembler 1 Tue Sep 22, 2020 9:26 pm

Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us