MVSFORUMS.com

[Biskhel]

Hi,

I want to splice two files but i am expecting the original order.

Ex:

File1:
1567<-------------------------remaining data--------------> LRECL - 200
8745
6785
1784

File2:
1567<---------------------------blank---------------upto 200--->ABCDEF
1784<------------DO---------------------------------------------->GFGGFG
8745<------------DO---------------------------------------------->TRCXDS
6785<------------DO---------------------------------------------->WBGFSD

Then i will concatenate File1 & File2 - File3

If i use SPLICE like this:

SPLICE FROM(File3) TO(File4) ON(1,4,CH) WITH(201,4) WITHALL
The File3 may be like this

1567<---------------remaining data from File1 up to 200-->ABCDEF
1784<---------------------------------------------------------->GFGGFG
6785<---------------------------------------------------------->WBGFSD
8745<---------------------------------------------------------->TRCXDS

But i want like this ( as it is in File1):
1567<---------------remaining data from File1 up to 200-->ABCDEF
8745<---------------------------------------------------------->TRCXDS
6785<---------------------------------------------------------->WBGFSD
1784<---------------------------------------------------------->GFGGFG

Please let me know your valuable solutions..

Biskhel




[url][/url]

[kolusu]

Biskhel,

You will need another pass to retain the original order of the keys. Add a seqnum to the file and and after the splice sort on that seqnum.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Frank Yaeger]

The SPLICE operator of DFSORT's ICETOOL sorts on the ON fields in order to bring duplicate records together so they can be spliced. As Kolusu says, if you want the spliced records to retain their original File1 order, you need to use a COPY operator to add sequence numbers to the File1 records, then use your SPLICE operator keeping the sequence numbers, and then use a SORT operator to sort on the sequence numbers and remove them.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

[Alain Benveniste]

bishkel,

you show 2 files with exactly the same keys, with no duplicates. I could suppose the files have the same number of records. Well i didn't spend much time to think about that particular case but I feel it could be done in 2 passes (not sure at all if it is possible). If it's how your files look like, i can spend a few time to dig out.

Alain

[Biskhel]

Hi Kolusu,Frank & Alain,

Thank you very much for your suggestions!


Bishkel