I have 4 files with a common primary key. Is there a way to SPLICE the 4 files with a single SPILCE command.
I tried pushing the files such a way that the whole format is created with space in between for induvidual files thinking that later when they are copied a straight SPLICE would merge it all in the required form
what I did was
But the space from the last record will override the fields above.
You can use WITHEACH to do that kind of thing. The first WITH(p,m) specifies the field you want from the first overlay record (e.g. ooooooooo in your example), the second WITH(p,m) specifies the field you want from the second overlay record (e.g. xx in your example), etc.
BTW, commas are not allowed between operands in SPLICE.