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
 

 

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 Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts Unable to create multiple files using... mbattu COBOL Programming 3 Fri May 05, 2017 5:35 pm
This topic is locked: you cannot edit posts or make replies. SDSF multiple spool datasets extracte... PJAlarcon CLIST & REXX 1 Fri Apr 21, 2017 10:50 pm
No new posts Group elements using ICETOOL Learncoholic DFSORT/ICETOOL 2 Fri Apr 14, 2017 11:01 am


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