IBM Mainframe Forum

My input file:


If i use

output is:


Why N5, N3 and N0 is not coming in the ID1, ID2 and ID3?
& if I use

Output:

Why again N5,N3,N0 is not coming in ID1,Id2,ID3?

Hello,

What is in CTL1?

Sorry due to some connectivity issue! i couldn't reply.
My CTL1 is
//CTL1CNTL DD *
INREC IFTHEN=(WHEN=(8,1,ZD,EQ,1),BUILD=(1,3,5:10,2,14:13,8)),
IFTHEN=(WHEN=(8,1,ZD,EQ,2),BUILD=(1,3,8:10,2,14:13,8)),
IFTHEN=(WHEN=(8,1,ZD,EQ,3),BUILD=(1,3,11:10,2,14:13,8))
/*

Can you show your expected output, and describe what you are trying to do.

For SPLICE FROM(IN1) TO(OUT) ON(1,3,CH) WITH(5,2) WITH(8,2) WITH(11,2)-
WITHEACH KEEPNODUPS USING(CTL1)

My expected output is:


For SPLICE FROM(IN1) TO(OUT) ON(1,3,CH) WITH(5,2) WITH(8,2) WITH(11,2)-
WITHALL KEEPNODUPS USING(CTL1)

My expected output is:

So try WITHANY.

If i use WITHANY, it works fine for first situation. But I'm not getting, why this is happening?
& for second case WITHANY doesn't work.

You have one other option, which is not to use any of them. If that doesn't "work" then what you want can't be done with SPLICE (at least not with one pass of the data).

If you set out exactly what you want, there might be suggestions for other ways to do it.

Read the description of the SPLICE options in the manual, and test them out to make sure you fully understand them anyway.

I have read the manual already. After that i'm discussing this issue with you. What I've done for the second case that is same as the manual talks about. But i'm receiving different output rather than expected output.
I have read the manual about WITHEACH & WITHANY. It is almost same but when i use WITHEACH instead of WITHANY. It doesn't work. Could you please help me, if i am wrong somewhere?

As far as I can see, and I tried your code, with your data, and modified it slightly repeated your results, SPLICE can't do what I "think" you want from what you have shown. I didn't try the default, but I don't think that'll get it for you either.

If you can describe exactly what you want, and illustrate it fully with sample input and required output, we can confirm whether or not in can be done with SPLICE in one pass, or whether there is another way it can be done using DFSORT/ICETOOL.

Please post the ICE201I message from a Sort step?