View previous topic :: View next topic
|
Author |
Message |
cpuhawg
Active User
Joined: 14 Jun 2006 Posts: 331 Location: Jacksonville, FL
|
|
|
|
I need some assistance on how to SPLICE the following together
Input 1
Code: |
ABENDAID TSCICS ALTER 0002
ABJ TSPWR ALTER 0001
ACTP CICSSTC ALTER 0001
ACTP CR9999 ALTER 0001
ADT0 AD ALTER 0001
ADT0 CR9999 ALTER 0001
ADT0 CSS ALTER 0001
ADT0 IS ALTER 0001
|
Input 2
Code: |
ABENDAID ABENDAID.** TSCICS ALTER 0002
ABENDAID ABENDAID.CICS*.** TSCICS ALTER 0002
ABJ ABJ.** TSPWR ALTER 0001
ACTP ACTP.** CICSSTC ALTER 0001
ACTP ACTP.** CR9999 ALTER 0001
ADT0 ADT0.** AD ALTER 0002
ADT0 ADT0.** CR9999 ALTER 0002
ADT0 ADT0.** CSS ALTER 0002
ADT0 ADT0.CIMS.** IS ALTER 0002
|
Output should look like:
Code: |
ABENDAID ABENDAID.** TSCICS ALTER 0002 0002
ABENDAID ABENDAID.CICS*.** TSCICS ALTER 0002 0002
ABJ ABJ.** TSPWR ALTER 0001 0001
ACTP ACTP.** CICSSTC ALTER 0001 0001
ACTP ACTP.** CR9999 ALTER 0001 0001
ADT0 ADT0.** AD ALTER 0002 0001
ADT0 ADT0.** CSS ALTER 0002 0001
ADT0 ADT0.CIMS.** IS ALTER 0002 0001
|
The splicing has to occur by position 1 for 8 and position 55 for 17. There may be multiple records on INPUT2 for a single record on INPUT1 (like the ABENDAID records). |
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
Just use two ON fields - ON(1,8,CH) ON(55,17,CH) and WITHALL in the SPLICE operator. |
|
Back to top |
|
|
cpuhawg
Active User
Joined: 14 Jun 2006 Posts: 331 Location: Jacksonville, FL
|
|
|
|
I attempted to use your suggestion and received the following error:
Code: |
* Splice the needed data from File1 and File2 together
SPLICE FROM(TEMP2) TO(COMBINE) ON(1,8,CH) ON(55,17,CH) WITHALL
ICE613A 0 REQUIRED KEYWORD MISSING: WITH
ICE602I 0 OPERATION RETURN CODE: 12
ICE601I 0 DFSORT ICETOOL UTILITY RUN ENDED - RETURN CODE: 12
|
|
|
Back to top |
|
|
cpuhawg
Active User
Joined: 14 Jun 2006 Posts: 331 Location: Jacksonville, FL
|
|
|
|
I used the following and was successful. Thank you for your time and input.
Code: |
SPLICE FROM(TEMP2) TO(COMBINE) ON(1,8,CH) ON(55,17,CH) WITHALL -
WITH(10,44) WITH(72,4)
|
|
|
Back to top |
|
|
|