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

Sync sort - Transpose


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
TS70363

New User


Joined: 07 Apr 2010
Posts: 94
Location: Bangalore, India

PostPosted: Tue Jun 28, 2016 3:18 am
Reply with quote

Hi,

Is it possible to concatenate all the records in a file?

My file may have up to 100 records, each 16 bytes and hence the output record may be 100*16 bytes...

Input file
Code:
11111111AAAAAAAA
22222222BBBBBBBB


Output File
Code:
11111111AAAAAAAA22222222BBBBBBBB



Thanks
TS70363
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Tue Jun 28, 2016 3:30 am
Reply with quote

What LRECL were you considering for the output file? What RECFM?
Back to top
View user's profile Send private message
TS70363

New User


Joined: 07 Apr 2010
Posts: 94
Location: Bangalore, India

PostPosted: Tue Jun 28, 2016 3:52 am
Reply with quote

Output RECFM = VB, LRECL=2004
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 2591
Location: NYC,USA

PostPosted: Tue Jun 28, 2016 8:20 am
Reply with quote

Why would you not do research and try ? Try this or look for RESIZE if supported by snycsort
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7311
Location: Inside the Matrix

PostPosted: Tue Jun 28, 2016 10:28 am
Reply with quote

If you have an undocumented RESIZE, that will be the best bet. You'll need a USING with OUTFIL to convert the fixed to variable (using FTOV or CONVERT).

Otherwise there is the SUM or WHEN=GROUP or SPLICE.

Although you'd end up with lots of repetitive stuff, you don't type it out yourself :-)
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


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

PostPosted: Tue Jun 28, 2016 2:44 pm
Reply with quote

As you specifically specify Syncsort and there is a specigfic part of the forum for Syncsort queries I fail to see why you have posted in the JCL part of the forum.

Moved.
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 Building a sort key DFSORT/ICETOOL 3
No new posts Very Large Sort failed - Seeking reco... DFSORT/ICETOOL 7
No new posts Date conversion using SORT SYNCSORT 4
No new posts Which SORT utility can improve the Pe... DFSORT/ICETOOL 16
No new posts Using sort on VB records based on off... DFSORT/ICETOOL 6
Search our Forums:

Back to Top