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
 
SPLICE option merging multiple records with ICETOOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
cpuhawg

Active User


Joined: 14 Jun 2006
Posts: 331
Location: Jacksonville, FL

PostPosted: Tue Jul 01, 2008 7:32 pm    Post subject: SPLICE option merging multiple records with ICETOOL
Reply with quote

I have a requirement to combine many records in to a single record. I know I can SPLICE the 10 files two by two, but would like to be able to accomplish this in one step, if possible.

Input view FB/30/27990:

Code:

----+----1----+----2----+----3
HLQUAL1  A                   
HLQUAL1    B                 
HLQUAL1      C               
HLQUAL1        F             
HLQUAL1          L           
HLQUAL1            N         
HLQUAL1              R       
HLQUAL1                T     
HLQUAL1                  U   
HLQUAL1                    V 
HLQUAL2  A                   
HLQUAL2    B                 
HLQUAL2        F             
HLQUAL2          L           
HLQUAL2              R       
HLQUAL2                T     
HLQUAL2                    V 
HLQUAL3  A                     
HLQUAL4                T       
HLQUAL4                  U     
HLQUAL4                    V   


Output should look like:

Code:

----+----1----+----2----+----3
HLQUAL1  A B C F L N R T U V   
HLQUAL2  A B   F L   R T   V   
HLQUAL3  A                     
HLQUAL4                T U V   


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

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Tue Jul 01, 2008 10:43 pm    Post subject:
Reply with quote

cpuhawg

I have answered a similar question of yours here . Cant you just apply the same logic shown in here to your current requirement?

http://www.ibmmainframes.com/viewtopic.php?p=110299#110299
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Inefficient BUILD - VB records paddin... Daniel Prosser SYNCSORT 4 Thu Dec 14, 2017 3:52 pm
No new posts ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts ICETOOL - RESIZE DYNAMICALLY kranthikumarb DFSORT/ICETOOL 0 Tue Nov 21, 2017 5:30 pm
No new posts Increment number for every group of r... srajendran2 DFSORT/ICETOOL 7 Thu Nov 09, 2017 10:31 pm

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