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
 
Sort to construct single record from number of rows of input

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> SYNCSORT
View previous topic :: :: View next topic  
Author Message
Deepti_R

New User


Joined: 07 Nov 2019
Posts: 3
Location: USA

PostPosted: Wed Nov 13, 2019 12:14 am    Post subject: Sort to construct single record from number of rows of input
Reply with quote

Hi,

My input is
3000ABC 176579
3000ABC 677856
3000ABC 987547
2000QWE 097580
2000QWE 457900

Can we use sort jcl to get desired output like this -
3000ABC 176579 677856 987547
2000QWE 097580 457900

Also, if then are there any constraints?

Thanks,
Deepti
Back to top
View user's profile Send private message

sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 825
Location: Maryland

PostPosted: Wed Nov 13, 2019 1:56 am    Post subject: Re: Sort to construct single record from number of rows of input
Reply with quote

Deepti_R wrote:
Can we use sort jcl to get desired output like this -
3000ABC 176579 677856 987547
2000QWE 097580 457900

Yes, you can - for a limited number of rows.

What did you try yet?

Deepti_R wrote:

Also, if then are there any constraints?

If there are any constraints, you can either ignore them, or take them into account - depending on your own needs. We have no info about them.
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2407
Location: Hampshire, UK

PostPosted: Wed Nov 13, 2019 2:36 am    Post subject: Reply to: Sort to construct single record from number of rows of input
Reply with quote

Quote:
Can we use sort jcl

No - for the simple reason that JCL does not manipulate data. However, you might be able to use the sort program if you use the correct sort control statements.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2467
Location: NY,USA

PostPosted: Wed Nov 13, 2019 8:43 pm    Post subject:
Reply with quote

Read here:
combining multiple records into one using ICETOOL or DFSORT
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
This topic is locked: you cannot edit posts or make replies. Parsing more than 1000 columns in a s... ssuthagar SYNCSORT 10 Tue Sep 22, 2020 12:23 am
No new posts Dynamically read input files using BP... Srinivas B COBOL Programming 20 Sat Sep 05, 2020 1:48 pm
No new posts Abend deletes last record written julietspringsteen ABENDS & Debugging 10 Fri Aug 21, 2020 7:45 pm
This topic is locked: you cannot edit posts or make replies. SORT the records based on the second ... Ramsee SYNCSORT 1 Wed Aug 19, 2020 3:01 pm
No new posts Required Date Format in Include Sort ... vivky_vivek DFSORT/ICETOOL 6 Fri Aug 14, 2020 6:52 am

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