Hi,
I am comparing 2 files and changing certain values in the master file. For this I am using the below mentioned splice statement.
SPLICE FROM(T1) TO(OUT) ON(13,11,CH) ON(30,4,CH) -
WITH(48,5) KEEPNODUPS
I really want only to compare the records, nut not to sort all the records based on (13,11,CH) and (30,4,CH). But this splice statement does a sort also, which I really don't want. Any solution for this.
pjnithin
This ICETOOL JOB retains the original order of the i/p records, and note that the preference is to the record in the first input file and can be changed as per your requirement.
pjnithin
You have to take up extra step of sorting to retain the original order, since the SPLICE operator will sort the i/p records based on the positions specified in ON(p,m,f).
There is no other go.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Quote:
other than by giving the rec count and sorting it again, is there any other method to rtain the order of the record after splicing it.
That's difficult to say since we don't know what your input records or output records look like.
Show an example of the records (relevant fields) in each input file and what you want for output. Give the RECFM and LRECL of the input files. Give the starting position, length and format of the relevant fields.