| IBM MAINFRAME HELP & SUPPORT FORUMS
Technical Forums for IBM Mainframe Applications like COBOL, JCL, CICS, DB2, FileAid, DFSORT, Endevor, Xpediter, CoolGen, CA-7&11, AbendAid, IMS, IDMS, PL/I, MqSeries, SyncSort, Assembler, ChangeMan, Easytrieve, InterTest, REXX, CLIST etc...
|
| View previous topic :: View next topic |
| Author |
Message |
cpuhawg
Joined: 14 Jun 2006
Posts: 280
Location: Jacksonville, FL
|
| Posted: Tue Jul 01, 2008 7:32 pm Post subject: SPLICE option merging multiple records with ICETOOL |
|
|
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 |
|
Skolusu
Joined: 07 Dec 2007
Posts: 357
Location: San Jose
|
| Posted: Tue Jul 01, 2008 10:43 pm Post subject: |
|
|
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 |
|
| |
THIS IS AN ARCIVE FORUM IN READ ONLY MODE. IF YOU WANT TO ASK YOUR DOUBTS USE THE ACTUAL FORUM
|
