Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Syncsort - put strings side by side

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

New User


Joined: 03 Mar 2014
Posts: 22
Location: India

PostPosted: Wed May 21, 2014 4:22 pm    Post subject: Syncsort - put strings side by side
Reply with quote

Hi,

Request your help to put below strings side by side in output file.

Code:

20130927021545470 BJ
140330 131231 3     


Expected Output:
Code:

20130927021545470 BJ140330


I tried below given SPLICE but unfortunately do not get expected output !

Code:

SPLICE FROM(IN1) TO(OUT1) ON(21,1,CH) KEEPBASE WITHALL WITH(1,15) -
WITH(1,20)                                                         


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

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7225

PostPosted: Wed May 21, 2014 6:01 pm    Post subject: Reply to: Syncsort - put strings side by side
Reply with quote

You have a file with only two records? What is the LRECL and RECFM?
Back to top
View user's profile Send private message
ramas.kamal

New User


Joined: 03 Mar 2014
Posts: 22
Location: India

PostPosted: Thu May 22, 2014 7:53 am    Post subject: Reply to: Syncsort - put strings side by side
Reply with quote

yes...only two records....LRECL=80,RECFM=FB
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7225

PostPosted: Thu May 22, 2014 12:07 pm    Post subject: Reply to: Syncsort - put strings side by side
Reply with quote

In INREC: IFTHEN=(WHEN=NONE, append a sequence number; IFTHEN=(WHEN=GROUP with BEGIN= for sequence number of one, and PUSH the entire record to an extension of the record.

Your output from INREC will be like this, conceptually:

Code:
data-a 1 bbbbb
data-b 2 data-a



With OUTFIL, have INCLUDE= for a value of two in the sequence number. Use BUILD to put the data together how you want it.
Back to top
View user's profile Send private message
ramas.kamal

New User


Joined: 03 Mar 2014
Posts: 22
Location: India

PostPosted: Thu May 22, 2014 2:32 pm    Post subject: Reply to: Syncsort - put strings side by side
Reply with quote

Bill, thank you for the idea......got the results !
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 syncsort: copy lines after the keyword shreya19 SYNCSORT 3 Fri Dec 02, 2016 9:47 am
No new posts Syncsort - Hard coded Value in output PORYES SYNCSORT 1 Thu Nov 03, 2016 9:23 am
No new posts Syncsort - NULL in Integer field chec... nartcr SYNCSORT 4 Thu Oct 06, 2016 6:47 am
No new posts ICETOOL/SYNCSORT - SYSPRINT output nartcr DFSORT/ICETOOL 17 Wed Oct 05, 2016 10:46 pm
No new posts Syncsort version supporting FINDREP c... juares castro SYNCSORT 9 Tue Aug 09, 2016 6:54 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us