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

Sort to construct single record from number of rows of input
IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic Quick References
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
 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

Senior Member


Joined: 29 Apr 2008
Posts: 2023
Location: USA
PostPosted: Wed Nov 13, 2019 1:56 am
 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: 2455
Location: Hampshire, UK
PostPosted: Wed Nov 13, 2019 2:36 am
 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: 3053
Location: NYC,USA
PostPosted: Wed Nov 13, 2019 8:43 pm
 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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 

Similar Topics
Topic Forum Replies
No new posts TRIM everything from input, output co... DFSORT/ICETOOL 1
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts To get the count of rows for every 1 ... DB2 3
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