Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Split into Multiple records based on delimiter

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

Active Member


Joined: 01 Dec 2006
Posts: 714
Location: Pennsylvania

PostPosted: Wed Mar 11, 2015 8:41 pm    Post subject: Split into Multiple records based on delimiter
Reply with quote

I have an input file which has multiple (virtual) records on each line.

I need to break each line into multiple lines each time the character '!' is found.

The number of occurrences on each line varies, and is unknown.

The input file is VB 23400. A sample record is here:
Code:
!LINE1   DATA1  !LINE2    DATA2!LINE3DATA3!LINE4 DATA4


The output file is VBM 32756. A sample is here:
Code:
!LINE1   DATA1
!LINE2    DATA2
!LINE3DATA3
!LINE4 DATA4


The process currently uses a Rexx exec provided by the vendor.

This is fine for small files, but larger ones (98,000 input to 9 million output), it runs for longer than desired.

I was looking for a Syncsort solution, but have not been able to create or find one.

Any help would be appreciated.
Back to top
View user's profile Send private message

Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Wed Mar 11, 2015 10:31 pm    Post subject: Reply to: Split into Multiple records based on delimiter
Reply with quote

Is there a maximum number of virtual lines? What is the maximum length?

If not more than 100, then PARSE with "blank record" dropping for the ones which aren't there for any given record.

There are some recent examples of similar things for fixed-length records. May be able to fix the lengths (OVERLAY=(23401:X), use SyncTool's RESIZE and work on that. It would be multiple passes of the data, and with "blank record" dropping, but it may work out.

There's always COBOL...
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7314

PostPosted: Wed Mar 11, 2015 10:49 pm    Post subject: Reply to: Split into Multiple records based on delimiter
Reply with quote

For instance, here, which contains two links as well. I see now that there is a query on the output from that...
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 Need help on the multiple files refor... wik123 DFSORT/ICETOOL 7 Wed Sep 19, 2018 10:47 am
No new posts Delete Multiple rows in chunks by usi... dharmaraok DB2 5 Tue Sep 11, 2018 8:44 pm
No new posts Concatenaing multiple rows to single ... Vignesh Sid DFSORT/ICETOOL 1 Tue Aug 14, 2018 8:59 am
No new posts Copy records with unknown LRECL oerdgie DFSORT/ICETOOL 8 Tue Jul 24, 2018 7:50 pm
No new posts Need Help to Create 4 Output Records ... satish.ms10 DFSORT/ICETOOL 5 Thu Jul 19, 2018 1:55 am

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